Activity Monitor-ing

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Activity Monitor-ing

Activity Monitor-ing

Rate Topic

Display Mode

Topic Options

Author

Message

reuben.anderson

Posted Thursday, January 06, 2011 4:11 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 15, 2013 8:28 AM
Points: 27, Visits: 135

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...

Post #1043620

« Prev Topic | Next Topic »

Permissions