SQL Server Locking and Blocking Tips
Concurrency
- Compare Repeatable Read and Serializable SQL Server Transaction Isolation Levels
- Prevent multiple users from running the same SQL Server stored procedure at the same time
Data Types
Deadlocks
- Capturing SQL Server Deadlock Information in XML Format
- Finding and troubleshooting SQL Server deadlocks
- Implementing SQL Server Transaction Retry Logic for failed transactions
- Monitor Deadlocks in SQL Server with system_health Extended Events
- SQL Server Deadlock Priority Configuration
- SQL Server Profiler Graphical Deadlock Chain
- SQL Server UPDATE lock and UPDLOCK Table Hints
- Using a Clustered Index to Solve a SQL Server Deadlock Issue
Hints
- Avoid using NOLOCK on SQL Server UPDATE and DELETE statements
- Compare SQL Server NOLOCK and READPAST Table Hints
- Execute SQL Server SELECT command without locking
- Processing Data Queues in SQL Server with READPAST and UPDLOCK
- SQL Server NOLOCK Anomalies, Issues and Inconsistencies
- Understanding the SQL Server NOLOCK hint
Indexing
IO
Locking
Monitoring
- Configuring Extended Events to find Locking Issues in SQL Server
- Detect and Automatically Kill Low Priority Blocking Sessions in SQL Server
- How to identify blocking in SQL Server
- Identify the cause of SQL Server blocking
Overview
- Demonstrations of Transaction Isolation Levels in SQL Server
- Understanding SQL Server Blocking
- Understanding SQL Server Locking
Performance
Scripts
- Locking and Blocking Scripts in SQL Server 2000 vs SQL Server 2005
- Monitoring SQL Server Blocked Sessions with SQLCMD
Statistics
T-SQL
Troubleshooting
- Eliminate False Positive SQL NOLOCK patterns in SQL Server - Part 3
- Find Blocking Processes Using SQL Server Profiler
- Find Problematic SQL NOLOCK Patterns in SQL Server DML Statements - Part 4
- Finding problematic NOLOCK patterns in SQL Server - Part 1
- Finding problematic SQL NOLOCK patterns for UPDATE and DELETE - Part 2
- How to Kill a Blocking Negative SPID in SQL Server
