Can anyone explain why Microsoft consistently make the Activity Monitor in SQL Server (whichever version) so very, very bad? As a Production DBA, the SQL 2008 is next to useless. The SQL 2000 version used to drive me insane. The SQL 2005 version was far from perfect, but it was their best to date... so they ditched it and made something worse.
I know I can use dmv's to retrieve the data I want, and I do this for specific investigations, but what I really want is a rapid, user friendly, dynamically updating snapshot of what's going as a generic starting point for my investigation.
And can anyone recommend a better GUI based monitor, preferably a free one? I would like it to;
- allow me to choose my own columns from those available in the dmv's.
- remember what I choose
- remember column widths
In some magical dreamland I would also be able to;
- define my own query to use including calculations, conditional formatting... sigh...
- right/double click on a process and choose view it's query, locks, metrics...
Surely, surely this is simple and obvious... the API is obviously there...