SQL Lock Escalation FAQ

SQL Lock Escalation can get crazy, read more to to know more Read more →

Blocked Process Report and how to read

the Blocked Process saved my bacon and has greatly assisted in troubleshooting SQL Blocking issue Read more →

SQL Server – How to use READ_COMMITED_SNAPSHOT isolation level

I received a SQL Server database specification which included instructions to enable READ_COMMITTED_SNAPSHOT . The main point of READ_COMMITED_SNAPSHOT is to manage access to versioned rows with the default READ COMMITED isolation level. READ COMMITED is the SQL Server Default Isolation Level. It’s managed via the lock mechanism , preventing dirty reads. When designing an application , consideration is given to locks held and for how long these locks are held. Decisions on concurrency can lead to a decision on whether READ_COMMITED_SNAPSHOT is used. The main difference between READ COMMITED and the READ_COMMITED_SNAPSHOT is no locks are placed on data... Read more →

LCK_M_IS sql wait type - how to reduce

Occurs when a task is waiting to acquire an Intent Shared (IS) lock Read more →

How to Find sql server Locks

How to find SQL Server Locks causing issues with Sys.dm_tran_locks Read more →