Apr 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 2016 – Wait Stats and Queues Script Updated – Identify Resource Bottlenecks

Pinal Dave
SQL Performance
SQL DMV, SQL Scripts, SQL Server, SQL Server 2016, SQL Wait Stats

NOTE: This script will just work fine with earlier version of SQL Server (2008, 2012, 2014) along with SQL Server 2016. It will give the expected results in all the SQL Server versions. This script will help you identify resource bottlenecks in your SQL Server.

A few years ago, I wrote the script which will help us identify SQL Wait Stats and Queues. It is a very popular script. You can find the link to the script over here: Introduction to Wait Stats and Wait Types. However, it has been a long time since I wrote that script and it was written for SQL Server 2008.

Read More

SQL SERVER – A Timeout (30000 milliseconds) was Reached While Waiting for a Transaction Response from the MSSQLSERVER

Pinal Dave
SQL
SQL Error Messages, SQL Server, SQL Wait Stats

Recently I was contacted by a client who reported very strange error in the SQL Server machine. These consulting engagements sometimes get the best out of you when it comes to troubleshooting. They reported that they see timeout error. My question was whether it connection timeout or query timeout which I explained in this blog post?

Read More