Once we fixed this issue of bottlenecks, we ended up on a very different issue where we had lots of runnable SPID and CPU was still underutilizing.
SQL SERVER – How to Shrink tempDB Database?
In the email yesterday from the client who earlier hired me for performance tuning had a small question about how to shrink tempdb database.
SQL SERVER – Show Primary Key for a Single Table – sp_pkeys
Recently, one of my clients showed me a very cool trick to check Primary Key for a single table with the help of the system stored procedure sp_pkeys.
SQL SERVER – Power Options, Power Plans and Database Performance
After a careful investigation into their system, we learned that this issue was with Power Options. Let us learn about that in this blog post.
SQL SERVER – Detecting CPU Pressure with Wait Statistics
I eventually expressed them it is possible to detect CPU pressure with Wait Statistics. We explained to them my method during the Health Check.
How to Skip Top N Rows in SQL Server? – Interview Question of the Week #237
Question: How to skip top N Rows in SQL Server and retrieve the rest of the rows? Answer: I had asked the above question in one of the interviews last week.
SQL SERVER – Patch Install Rule Error – Not Clustered or the Cluster Service is Up and Online
The error which we observed was a failure of a rule – Patch Install Rule Error – Not clustered or the cluster service is up and online.
SQL SERVER – Changing Max Worker Count for Performance
I wrote a blog post about SQL SERVER – Best Value for Max Worker Count, after reading this blog post, I have received lots of emails.
SQL SERVER – DELETE Qualified Rows From Multiple Tables – Part 2
This is a follow-up blog post of the Winners and Solution – DELETE Qualified Rows From Multiple Tables. Today we will see another efficient solution.
SQL SERVER – Best Value for Max Worker Count
Recently, one of my client who works for the large bank accidentally set incorrect max worker count, which lead to big performance problem.