Let us understand how we can quickly identify the workload type of read-heavy or write-heavy by counters. Comprehensive Database Performance Health Check
I have received an interesting email from a client of Comprehensive Database Performance Health Check. His question was related to files with IO Issues.
Question received via email: The question was about is there any way to know how many rows each thread execute in parallel operations.
Recently, while working with the customer who had a Memory issue, we ended up talking about Clean Pages and Dirty Pages Count.