HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Checking lock granularity

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
granularitycheckinglock

Problem

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?

Solution

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.

Context

StackExchange Database Administrators Q#12539, answer score: 4

Revisions (0)

No revisions yet.