Wait Statistics are the Bread and Butter of Performance Tuning

By: Thomas LaRock


Yes, it’s true. Don’t believe me? Fine then, would you believe Paul Randal? It’s a simple fact, really. If you know what your queries are waiting for, then you know how to improve performance. And that is why customers LOVE SolarWinds Database Performance Analyzer, because we put the statements and waits right in front of you for analysis. We don’t try to dazzle you with lots of fancy terms, or graphs that depend upon some rudimentary baseline analysis, or deploy agents to run a server side trace that gathers unnecessary details.

No, we approach performance tuning from a very practical standpoint. We use T-SQL to capture the statements that are running and the events that those statements are waiting for. If your current performance monitoring system is not able to capture wait events then you are missing out.

Why not download a trial version of SolarWinds DPA and see how we can transform you from a database professional into a database hero.

Comments

Leave a Reply