Last week, I had published 3 videos on CPU, Linux, and Shutdown. I received lots of good feedback on each of them and also got lots of questions.
Get CPU Details – SQL in Sixty Seconds #164
I understand that there is no one way to describe the CPUs and that is the primary reason, why I get a different answer when I try to get CPU details.
SQL SERVER – AdHoc Queries and Optimize for Adhoc Workloads
Discussion with a client during the Comprehensive Database Performance Health Check. The topic is AdHoc Queries and Optimize for Adhoc Workloads.
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.Â
Find Expensive Queries – SQL in Sixty Seconds #159
Earlier I wrote a blog post about SQL SERVER – List Expensive Queries – Updated March 2021. Let us learn how to Find Expensive Queries.
SQL SERVER – List Expensive Queries – Updated March 2021
One of my favorite scripts which I discuss with my client during Comprehensive Database Performance Health Check is how to get a list of Expensive Queries.
SQL SERVER – RESOURCE SEMAPHORE and THREADPOOL
RESOURCE SEMAPHORE and THREADPOOL. They are indeed very troublemaking wait statistics and they indeed talk about Memory and CPU issues.