Trace Flag 1211 Not Working - SQL Server 2008 R2
- by psam
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