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.
SQL SERVER – Fix: Logical Name Mismatch Between Catalog Views sys.master_files and sys.database_files
In this blog, I am going to share my learning about the mismatch between catalog views sys.master_files and sys.database_files.
SQL SERVER – Clean Pages and Dirty Pages Count – Memory Buffer Pools
Recently, while working with the customer who had a Memory issue, we ended up talking about Clean Pages and Dirty Pages Count.