I wrote a blog post about SQL SERVER – Best Value for Max Worker Count, after reading this blog post, I have received lots of emails.
SQL SERVER – Best Value for Max Worker Count
Recently, one of my client who works for the large bank accidentally set incorrect max worker count, which lead to big performance problem.
SQL SERVER – List All Frequently Ran Stored Procedure From Server Cache
We started working with my Comprehensive Database Performance Health Check service and found very interesting details from the server cache.
SQL SERVER – Number of Rows Read Per Threads in Parallel Operations
Question received via email: The question was about is there any way to know how many rows each thread execute in parallel operations.
SQL SERVER – Script to Enable PAGE and ROW Level Compression – Disable Compression
Comprehensive Database Performance Health Check Client sent me an SOS message for help . The entire issue was about Page and Row level compression.
SQL SERVER – Audit Script to Get CPU and Memory Information with MAXDOP Guidelines
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.
SQL SERVER – Difference Between Status in SP_Who2 – Running, Pending, Runnable, Suspended, Sleeping
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.