One of the interesting question: Is it possible to Override Server’s Configuration of Max Degree of Parallelism? Of course, it is possible, let us read.
SQL SERVER – T-SQL Script to Identify TOP 10 Parallel Running Queries
Today we see T-SQL Script to Identify TOP 10 Parallel Running Queries which I wrote as a part of my Comprehensive Database Performance Health Check.
SQL SERVER – Limitation of ENABLE_PARALLEL_PLAN_PREFERENCE Hint
I received quite a few interesting emails. One of the emails was about the Limitation of ENABLE_PARALLEL_PLAN_PREFERENCE Hint.
SQL SERVER – Lots of Runnable SPID – What Next?
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 – 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.
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 – 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.