Whenever I end up on a situation where we have lots of blocking issues with my client, I depend on the script of the Blocking Tree.
SQL SERVER – Query for CPU Pressure
How do I actually measure the CPU for the entire server? In today’s blog post we will discuss Query for CPU Pressure and its script to identify the same.
What is the Difference Between sql_handle and plan_handle?- Interview Question of the Week #269
Question: What is the Difference Between sql_handle and plan_handle?
Answer: I was recently asked this question. Let us see the answer today.
SQL SERVER – Scheduler_ID with Large Number in dm_os_schedulers
The other day, I had a very interesting conversation with one of my clients about Scheduler_ID With a Large Number in dm_os_schedulers.
SQL SERVER – Top Reasons for Slow Performance
Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. Let us discuss this topic today.
SQL SERVER – Drop All Auto Created Statistics
During the recent consulting engagement, I ended up a very interesting situation where I had to drop all the auto created statistics.
How to Measure Transactions Per Seconds in SQL Server? – Interview Question of the Week #262
Question: How to Measure Transactions Per Seconds in SQL Server?
I have updated the script for this for Comprehensive Database Performance Health Check.