In this blog post, we will learn about how to fix the performance issue with the malicious Wait Type. Comprehensive Database Performance Health Check
I walked into a client engagement where I really got stuck with a very interesting scenario with a client with PREEMPTIVE_OS_RSFXDEVICEOPS Wait Type.
Today we will see Brief Note About RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Type resource. I wrote a blog post about Enable Lock Pages in Memory LPIM.
This was a very interesting situation and at the end of we had found the culprit for the slow query and resolved it. Today we will discuss the experience.
I eventually expressed them it is possible to detect CPU pressure with Wait Statistics. We explained to them my method during the Health Check.
I wrote a blog post about SQL SERVER – Best Value for Max Worker Count, after reading this blog post, I have received lots of emails.
After a quick research we figured out the issue was with memory requirement for their query and we used to query specific wait statistics.