The Server is running Slow!
I hear this at least once a week (on a bad day, multiple times per day). The question is what do you mean by slow and how do I find the culprit.
In the good old SQL 2000 days we'd have to use Perfmon, watch the results interactively or save it to a table to do trend analysis.
With the advent of SQL 2005, all of this changed with Dynamic Managment Views. Now we can access all of this information quicker faster and with lower resource overhead.
The sp is very simple, the only input parameter is the number of seconds to wait while it collects the data.
The only aspect of SQL that this proc does not address is the disk subsystem. This section is very much a moving target as some of the paramters do not always translate over to SAN storage or Solid State Drives.
