02-09-12, 06:27 #1Registered User
- Join Date
- Jan 2006
Unanswered: Checking lock granualrity in SQL Server
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 granularity in SQL Server 2008? How do I do that?