Sean Lange (12/26/2012)
The locking you are seeing is because of lock escalation.
It's not lock escalation.
Truncate table locks at the table level because there's no other sensible level to lock at (and iirc it takes an Sch-M lock too)
Lock escalation would be if the truncate first started taking row or page locks, got over the threshold and converted the locks to table
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass