A client’s server slowed down with no CPU, IO or memory issue. The culprit was power options. Here is how power plans and database performance connect.
SQL SERVER – Detecting CPU Pressure with Wait Statistics
I eventually expressed them it is possible to detect CPU pressure with Wait Statistics. We explained to them my method during the Health Check.
SQL SERVER – Changing Max Worker Count for Performance
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.
Filtered Statistics: Fixing Estimates for Skewed Data
Use filtered statistics to describe skewed customer values, inspect histograms, and test estimates under literal and parameterized queries.
SQL SERVER – Query Specific Wait Statistics and Performance Tuning
After a quick research we figured out the issue was with memory requirement for their query and we used to query specific wait statistics.
SQL SERVER – Performance Impact of Unique Index
In the latest Comprehensive Database Performance Health Check engagement, we had a very interesting situation of Performance Impact of Unique Index.
SQL SERVER – Performance Monitoring Tool – SQLGrease
Today, we are going to see another SQL Server Performance Monitoring Tool – SQLGrease in the same spirit as I have evolved others.