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 Puzzle – SELECT ~ 1 : Guess the Answer
Of course, I have one where you have to guess the answer for a simple select statement. Let us see if you can guess it correctly or not.
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.
Azure Free Courses at Pluralsight
I also work on SQL Azure, MySQL, MariaDB, PostgreSQL as well as Visualization areas. I am going to share details about Azure Free Courses at Pluralsight.
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.