Is there a way to find the current setting for LOCK_ESCALATION on particular table? Can it be found through system views?
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.
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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