SQL Server 2008 - get current LOCK_ESCALATION on particular table Is there a way to find the current setting for LOCK_ESCALATION on particular table? Can it be found through system views?
As far as I know, you'd have to look using SQL Server Profiler, the Lock:Escalation event

Esclation information isn't in sys.dm_tran_locks or it's predecessors