I had a great discussion about Thread Management for Performance Improvement with my client, who recently hired me for Comprehensive Database Performance Health Check.
CPU Running 100% – SQL in Sixty Seconds #185
I got lots of responses to this blog and people wanted me to create a video for this topic. Here, I have a video for CPU Running 100%.
SQL SERVER – CPU Scheduler Waiting On Disk
Comprehensive Database Performance Health Check. Let us figure out today a very simple and effective script for CPU Scheduler Waiting On Disk.
SQL SERVER – Troubleshooting High CPU
We are going to discuss Troubleshooting High CPU in SQL Server. This is why many hire me for Comprehensive Database Performance Health Check.
SQL SERVER – Parallelism in Express Edition
Recently a client reached out to me with a very interesting question, why is he not able to see the parallelism in Express Edition. Let us discuss today.Â
SQL SERVER – Table Variables, Temp Tables and Parallel Queries
I heard an interesting comment from a client and that made me write a blog post. Their point was about table variables, temp tables, and parallel queries.
Best Value for Maximum Worker Threads – SQL in Sixty Seconds #170
A very common question I often receive during Comprehensive Database Performance Health Check is what is the best value for Maximum Worker Threads.