A friend’s SQL Server in an Azure VM slowed down suddenly. Here is my handy script using sys.dm_io_pending_io_requests to see current IO related waits.
CXSYNC_PORT and CXSYNC_CONSUMER Waits in Parallel Queries
Investigate CXSYNC_PORT with session wait deltas, parallel plan exchanges and thread rows before testing a query-level MAXDOP change.
Is It the Database? Reading ASYNC_NETWORK_IO
Investigate ASYNC_NETWORK_IO with request and task evidence, check client consumption, and separate large outputs from network faults.
Azure SQL Database Wait Stats: Reading sys.dm_db_wait_stats
Read Azure SQL Database wait stats with sys.dm_db_wait_stats, identify log-rate governance, and compare resource percentages before scaling.
Reading the Top Five Wait Types on Your Server
Top five wait types become useful when you filter background waits, measure changes over time, and connect them to active work.
Index Usage Stats Reset: Reading Them Without Being Fooled
Use index usage stats reset in SQL Server with practical examples, clear checks, and the limits you need before changing your database.
Signal Waits: Telling CPU Pressure From Slow Disks
Measure signal waits over an interval, compare scheduler queues and file latency, and separate CPU scheduling pressure from storage delays.