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.
Question: How Much Memory is in Locked Pages? Answer: Before we see the answer to this question, I suggest you read the blog post here first.