During the consultation, one of the questions was is there any way to see the information about the partition for any database.
SQL SERVER – Find All Tables Containing Specific Column Name
During the recent Comprehensive Database Performance Health Check, I was asked if I know any trick to identify column with a Specific Name in the database.
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 – 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 – 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 – 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.
SQL SERVER – Number of Rows Read Per Threads in Parallel Operations
Question received via email: The question was about is there any way to know how many rows each thread execute in parallel operations.