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.
SQL SERVER – 5 Important Steps When Query Runs Slow Occasionally
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.
SQL SERVER – Generate In-Memory OLTP Migration Checklists – SSMS
One of the customers of Comprehensive Database Performance Health Check asked me if I can help them analysis their database for In-Memory OLTP Migration.
SQL SERVER – T-SQL Script to Identify TOP 10 Parallel Running Queries
Today we see T-SQL Script to Identify TOP 10 Parallel Running Queries which I wrote as a part of my Comprehensive Database Performance Health Check.
SQL SERVER – Using Query Hint ENABLE_PARALLEL_PLAN_PREFERENCE
There are so many options you should experiment before you opt for query hint. Recently DBA asked me how to use query hint ENABLE_PARALLEL_PLAN_PREFERENCE.Â
SQL SERVER – Stop Using DBCC DBREINDEX and Use ALTER INDEX
It has been over a decade since the comment DBCC DBREINDEX has been deprecated, however, once in a while I still encounter them while working with clients.
SQL SERVER – Identify Read Heavy Workload or Write Heavy Workload Type by Counters
Let us understand how we can quickly identify the workload type of read-heavy or write-heavy by counters. Comprehensive Database Performance Health Check