Recently, one of my client who works for the large bank accidentally set incorrect max worker count, which lead to big performance problem.
We started working with my Comprehensive Database Performance Health Check service and found very interesting details from the server cache.
Question received via email: The question was about is there any way to know how many rows each thread execute in parallel operations.
Comprehensive Database Performance Health Check Client sent me an SOS message for help . The entire issue was about Page and Row level compression.
If you are reading this blog regularly the name of Dominic Wirth may not be new for you. He has in the past sent some very interesting scripts for audit for our blog and I am including his new script in this blog which is about how to Get CPU and Memory Information with MAXDOP Guidelines.
One of the most popular questions I receive during my Comprehensive Database Performance Health Check is a difference between status in sp_who2 which discusses status as Running, Pending, Runnable, Suspended. Let us today understand them with regards to CPU.
How to Know When Memory Constraints are Negatively Impacting CPU in SQL Server? – Interview Question of the Week #216
Question: How to Know When Memory Constraints are Negatively Impacting CPU in SQL Server?