After a network outage, queries stayed in KILLED/ROLLBACK with the undocumented wait PREEMPTIVE_OLEDB_RELEASE. What I saw and how to clear them.
Resource Bottlenecks in SQL Server: A Wait Stats Script That Groups Them
Resource bottlenecks hide in the wait statistics, under a pile of idle waits and totals since startup. This post builds a script that removes the idle waits, measures an interval and groups the rest by resource. It also explains how to read each group and the signal wait.
SQL SERVER – A Timeout (30000 milliseconds) was Reached While Waiting for a Transaction Response from the MSSQLSERVER
Event ID 7011: a timeout was reached while waiting for a transaction response from MSSQLSERVER. It happened when my client expanded an Oracle linked server.
SQL SERVER – Finding Waits For Any Session with Extended Event wait_info
It becomes a great win-win situation. Let us learn about Extended Event wait_info in this blog post. Do you think this script will be useful for you?
SQL SERVER – Script: Current IO Related Waits on SQL Server
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.