May 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – DMV – sys.dm_os_wait_stats Explanation – Wait Type – Day 3 of 28

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Wait Stats
The key Dynamic Management View (DMV) that helps us to understand wait stats is sys.dm_os_wait_stats; this DMV gives us all the information that we need to know regarding wait stats. However, the interpretation is left to us. This is a challenge as understanding wait stats can often be quite tricky. Anyway, we will…
Read More

SQL SERVER – Introduction to Wait Stats and Wait Types – Wait Type – Day 1 of 28

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Wait Stats
I have been working a lot on Wait Stats and Wait Types recently. Last Year, I requested blog readers to send me their respective server’s wait stats. I appreciate their kind response as I have received  Wait stats from my readers. I took each of the results and carefully analyzed them. I…
Read More

SQL SERVER – DMV – sys.dm_exec_query_optimizer_info – Statistics of Optimizer

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL DMV, SQL Scripts
Incredibly, SQL Server has so much information to share with us. Every single day, I am amazed with this SQL Server technology. Sometimes I find several interesting information by just querying few of the DMV. And when I present this info in front of my client during performance tuning consultancy, they are surprised…
Read More

SQL SERVER – Find Total Number of Transactions on Interval

Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server, SQL System Table

In one of my recent Performance Tuning assignment I was asked how do someone know how many transactions are happening on server during certain interval. I had handy script for the same. Following script displays transactions happened on server at the interval of one minute. You can change the WAITFOR DELAY to any other interval and it should work.

Read More
Exit mobile version