During Comprehensive Database Performance Health Check I recently faced a brand new wait type WAIT_ON_SYNC_STATISTICS_REFRESH.
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.