Is there a way to find the current setting for LOCK_ESCALATION on particular table? Can it be found through system views?
Tell me more
×
Database Administrators Stack Exchange is a question and answer site for
database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
|
|
|
As far as I know, you'd have to look using SQL Server Profiler, the Esclation information isn't in sys.dm_tran_locks or it's predecessors |
|||
|
|
