Trace Flag 1211 Not Working - SQL Server 2008 R2
Posted
by
psam
on Stack Overflow
See other posts from Stack Overflow
or by psam
Published on 2012-04-10T11:18:32Z
Indexed on
2012/04/10
11:29 UTC
Read the original article
Hit count: 188
During a SSIS load, when an employee table is getting updated, locking comes into effect.
However, have disabled lock escalation on the table using the following statements:
ALTER TABLE dbo.Employee SET (LOCK_ESCALATION = DISABLE)DBCC TRACEON (1211,-1)
However, the table (object) does get locked and is held for almost an hour. The total no. of updates (insert, update, delete statements) are approx 200,000
© Stack Overflow or respective owner
