Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Activity Monitor-ing Expand / Collapse
Author
Message
Posted Thursday, January 6, 2011 4:11 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 3:36 AM
Points: 55, Visits: 166
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
Posted Wednesday, November 27, 2013 12:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 12:24 PM
Points: 1, Visits: 48
And can anyone recommend a better GUI based monitor, preferably a free one?


Crickets......
Post #1518180
Posted Thursday, November 28, 2013 6:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 5, 2014 6:19 AM
Points: 147, Visits: 591
Hi,
You can make use of SSRS to develop custom reports.




Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com
Post #1518340
Posted Thursday, November 28, 2013 6:22 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 4,278, Visits: 3,717
There's nothing free I know of that does all that. You can, as pointed out, query the DMVs to get what you're after. Tim Ford created a "Periodic Table of DMVs" that you may find helpful. It's at http://thesqlagentman.com/periodic-table/.

If you want to buy a professional tool, I use SQL Sentry. It isn't free, but it covers a lot of territory.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1518428
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse