Tag: Blocking
-
Troubleshoot SQL Server Blocking, Step by Step
Blocking isn’t a bug, it’s SQL Server enforcing correctness: one session holds a lock, another wants a conflicting one, and it has to wait. Most blocking resolves in milliseconds and nobody notices. The problem is blocking that doesn’t resolve fast, a query queued behind a session that’s holding a lock far longer than it should,…
Written by
-
Reading and Fixing a SQL Server Deadlock
A deadlock is SQL Server refusing to let two sessions wait on each other forever. Session A holds a lock Session B needs, Session B holds a lock Session A needs, neither can proceed, so the deadlock monitor picks one as the victim, kills it with error 1205, and lets the other continue. That’s the…
Written by
-
DBA Scripts: Performance and Troubleshooting
Part of the DBA-Tools Project. Four Ways of Answering “Why Is It Slow” “The database is slow” is rarely one problem. Sometimes it’s a query, a bad plan, a stale statistic. Sometimes it’s blocking, and the fix is completely different depending on which one it actually is. Sometimes the DMV snapshot has already missed the…
Written by
-
DBA Scripts: Collect Blocking and Deadlock Events
Part of the DBA-Tools Project. Standing Watch for Blocking and Deadlocks, Not Just Checking When Asked Get Blocking Sessions and Get Deadlock Summary answer “what’s happening right now.” These two generators answer a different question: “what happened while nobody was looking.” Each creates a small recurring SQL Agent job that writes evidence into a DBAMonitor…
Written by
Blog Categories
- Backups & Recovery (7)
- DBA Scripts (130)
- High Availability (HA) (7)
- Installation & Configuration (14)
- Maintenance (4)
- Monitoring (13)
- Performance Tuning (11)
- Security (Encryption & Permissions) (4)
- T-SQL Fundamentals (11)
- Troubleshooting (20)
- Wait Types (235)
Latest Posts
- DBA Scripts: Run a Full SQL Server Health Check
- Diagnose SQL Server’s ‘String or Binary Data Would Be Truncated’ Error
- Shrinking a SQL Server Database Causes Fragmentation: Measured, Not Just Stated
- DBCC CHECKDB Found Corruption: What to Actually Do Next
- Parameter Sniffing in SQL Server: A Measured Example, Not Just the Theory
- Table Variables vs Temp Tables in SQL Server: What the Optimizer Actually Sees
Blog Tags
Access (3) Always On Availability Groups (4) Auditing (7) Backups (6) Blocking (4) Blocking Locking (6) Collectors (7) Database Backups & Recovery (8) Database Backups and Recovery (5) Database Maintenance (7) DBA Tools (24) Disk Space (5) Extended Events (8) Features (6) High Availability (6) Indexes (7) Installation (7) Instance (3) Inventory (8) Maintenance (7) Migration (15) Monitoring (27) Performance (21) Performance Troubleshooting (9) PowerShell (4) Query Behaviour (5) Security (9) SQL Agent (5) SQL Scripts (17) SQL Server Administration (10) SQL Server Configuration (7) SQL Server Errors (5) SQL Server High Availability (4) SQL Server Internals (3) SQL Server Management Studio (SSMS) (6) SQL Server Monitoring (7) SQL Server Networking (9) SQL Server Security (7) Storage and Capacity (7) T-SQL (10) Temp DB (3) Tracing (7) Transaction Logs (4) Troubleshooting (24) Windows Server (4)