Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
I understand in SQL Server there are various levels of granularity for locks...RID, Key, Page, Extent, Table, DB.
Forgetting about lock escalation, I just want to check the default level of lock granularity in SQL Server 2008? How do I do that?
After comments on questions
You can query sys.indexes, looking at the allow_row_locks and allow_page_locks columns. Also, sys.tables has a column lock_escalation
I think that will allow you to find all non-default options about locks.
Required, but never shown