One of the most popular conversations during Comprehensive Database Performance Health Check is about CPU and memory issues.
SQL SERVER – Map SQL Server Session ID to OS Thread ID
He wanted to track the OS Thread ID in Performance Monitor. He asked me if I know any script which can Map SQL Server Session ID to OS Thread ID.Â
SQL SERVER – Parallelism and Threads with No Work
One of my repeat clients asked me if a query goes to parallel do they use all the threads. We can have parallelism and thread with no work.
SQL SERVER – Top 1 and Index Scan
Scans are not always bad they are there because they are needed. Let us see a very simple demonstration about Top 1 and Index Scan.
SQL SERVER – Cached Data Per Object in Memory
“How to build a list of cached data per object in memory pool?” I just received this question from my client who hired me for Health Check.
SQL SERVER – Disable Adaptive Joins
My client sent me an interesting scenario where a query with adaptive join was performing badly. Let us learn how to disable adaptive joins.Â
SQL SERVER – Enable Adaptive Join
Let us learn how we can enable the adaptive join feature in SQL Server. I often discuss this during Comprehensive Database Performance Health Check.