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 for 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.
Glad if you can let me know the T-SQL used get to the statements waiting for.