Seeing many BACKGROUND threads with command VDI_CLIENT_WORKER? Here is what the VDI_CLIENT_WORKER and VDI_CLIENT_OTHER wait types mean.
SQL SERVER – Wait Stats Collection Scripts for 2016 and Later Versions
Are my Wait Stats Collection Scripts still valid for SQL Server 2016 and later? Yes, they work on every version. Here they are, with a few recent enhancements.
SQL SERVER – Get Wait Stats Related to Specific Session ID With sys.dm_exec_session_wait_stats
From SQL Server 2016, sys.dm_exec_session_wait_stats shows wait stats for a specific session ID. Here is how to use it, and why it fails on older versions.
SQL SERVER – 3 Different Usage of DBCC SQLPERF
Have you ever wondered what DBCC SQLPERF does? Here are three uses: checking log space, resetting wait statistics and resetting latch statistics.
SQL SERVER – Queries are in KILLED/ROLLBACK State with Wait PREEMPTIVE_OLEDB_RELEASE
After a network outage, queries stayed in KILLED/ROLLBACK with the undocumented wait PREEMPTIVE_OLEDB_RELEASE. What I saw and how to clear them.
SQL SERVER – 2016 – Wait Stats and Queues Script Updated – Identify Resource Bottlenecks
My popular Wait Stats and Queues script, now updated for SQL Server 2016. It works on 2008, 2012 and 2014 too and helps you identify resource bottlenecks.
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.