SQL Server/Troubleshooting

SQL Server Troubleshooting Guides

End-to-end playbooks for 42 common SQL Server performance problems, from initial diagnosis through resolution and prevention.

Administration(2)

Database Mail Issueslow SQL Agent Failuresmedium

Authentication(1)

Error 18456 All Statesmedium

Backup & Recovery(1)

Backup Performancemedium

Columnstore(1)

Columnstore Maintenancemedium

Concurrency(3)

Blocking Chainshigh Deadlock Analysiscritical Lock Escalationmedium

Connectivity(1)

Connection Pool Exhaustionhigh

CPU(1)

CPU Saturationcritical

High Availability(1)

Always On AG Latencyhigh

I/O(1)

Disk I/O Bottleneckhigh

Index Maintenance(4)

Missing Indexesmedium Index Fragmentationmedium Key Lookup Performancemedium Page Split Optimizationmedium

Linked Server(1)

Linked Server Performancemedium

Maintenance(1)

DBCC CHECKDB Strategymedium

Memory(3)

Memory Pressurecritical Plan Cache Bloatmedium Buffer Pool Extensionlow

Migration(1)

Azure SQL Migrationlow

Platform(1)

SQL Server on Linuxlow

Query Optimization(6)

Parameter Sniffinghigh Query Timeoutshigh Stale Statisticsmedium Implicit Conversionsmedium Excessive Recompilationmedium Query Store Tuningmedium

Security(2)

TDE Performance Impactlow Contained Database Authenticationlow

Server Configuration(4)

MAXDOP Configurationmedium Cost Threshold for Parallelismmedium Max Server Memoryhigh NUMA Configurationlow

Storage(4)

Transaction Log Growthhigh Auto-Growth Configurationmedium Instant File Initializationlow Partitioning Strategymedium

TempDB(2)

TempDB Contentionhigh TempDB Configurationmedium

Transaction Log(1)

High VLF Countmedium