I am honored to be a Guest Blogger at SQLPerformance.com. As a member of the SentryOne Product Advisory Council (PAC) I will be writing occasionally for the site. You can catch my first blog post It’s Not You It’s Me (I/O Troubleshooting) through simple changes. SQLPerformance.com is about providing innovative and practical solutions for improving SQL Server performance. Whether you are running a 3rd party application database where very little can be changed, or you are a DBA at a site where getting the application developers to change anything is next to impossible, they cover both the “how” and the “why.”
-
-
My life for the last 2 years has been a constant battle of putting out fires with system performance; finally user complaints have moved getting this resolved as my top priority. Let’s see how I tackled the problem… Symptoms: Very High Disk Latency as high as 300,000 milliseconds (ms) is not unusual Average: 900 – 15,000ms Memory Pressure Slow User Experience Problem: Bad hardware Over-provisioned VM Hosts (what happens on one VM effects the other) Old NetApp SAN No infrastructure budget for new hardware Challenge: Make the system viable with no hardware changes or tweaks Step 1: Brain Storming (in no particular order) Reduce I/O I can probably tune a ton…
