There are so many options you should experiment before you opt for query hint. Recently DBA asked me how to use query hint ENABLE_PARALLEL_PLAN_PREFERENCE.
SQL SERVER – Stop Using DBCC DBREINDEX and Use ALTER INDEX
It has been over a decade since the comment DBCC DBREINDEX has been deprecated, however, once in a while I still encounter them while working with clients.
SQL SERVER – Identify Read Heavy Workload or Write Heavy Workload Type by Counters
Let us understand how we can quickly identify the workload type of read-heavy or write-heavy by counters. Comprehensive Database Performance Health Check
SQL SERVER – 3 Different Ways to Explore Actual Execution Plans
We will explore 3 different ways to explore Actual Execution Plans. I had discussed this Comprehensive Database Performance Health Check.
SQL SERVER – Identify Database File with Maximum IO Issues
I have received an interesting email from a client of Comprehensive Database Performance Health Check. His question was related to files with IO Issues.
SQL SERVER – Removing Extra TempDB Files
The other day I ended up a very interesting situation while working with Comprehensive Database Performance Health Check, with TempDB files.
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.