Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Monitor


SQL Monitor

Author
Message
scogeb
scogeb
SSC Journeyman
SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)

Group: General Forum Members
Points: 78 Visits: 420
Is anyone using SQL Monitor to monitor their SQL instances? Per this thread http://www.sqlservercentral.com/Forums/Topic1394075-1550-1.aspx, I'm looking to monitor about 40 instances across multiple domains. I like the regular metrics, but I'm really interested in the custom metrics too. I'd like to query certain instances for certain things and then email specific people the results if thresholds are met. Anyone doing that with this product? It looks awesome on paper, but I'd like some real world feedback. Thanks!
MyDoggieJessie
MyDoggieJessie
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4905 Visits: 7365
I personally prefer SQL Diagnostic Manager (praying I don't get attacked from mentioning an Idera tool on here ;-)) - In my testing I liked the way the data was presented (charts, metrics, etc) and it comes with so many "neat" features (one of which is the ability to completely customize the layout of the dashboard and built custom metrics).

I know that's not really what you asked for in your post but thought I'd throw it out there in case you never had a chance to evaluate it

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience" ;-)
Bhuvnesh
Bhuvnesh
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2928 Visits: 4076
scogeb (12/18/2012)
Anyone doing that with this product? It looks awesome on paper, but I'd like some real world feedback. Thanks!
i would say use the trial version first then though there would be some limitations for that too but you can get some light definitely

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
slim.richard
slim.richard
SSC Rookie
SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)

Group: General Forum Members
Points: 25 Visits: 355
I use SQL Monitor for 5 of my main instances and use Custom Metrics a lot do do what you mention, works great and very customisable. I would recommend it to anyone :-) PM me if you need any more details about how they work.
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36146 Visits: 18751
MyDoggieJessie (12/18/2012)
I personally prefer SQL Diagnostic Manager (praying I don't get attacked from mentioning an Idera tool on here ;-)) -


Nope, it's fine with me. If you like it, that's fine.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36146 Visits: 18751
We use it here at SQLServerCentral. We expose the data at monitor.red-gate.com. It's delayed slightly and replicated to another server for the public side, but you can play with lots of it. We even have custom metrics, both performance and business related ones.

Monitor is built to monitor and alert. That's it's focus. Some of the other products are more for digging in and troubleshooting. It depends on what's more important to you. I'd say test them, think about what you need, and then decide.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
scogeb
scogeb
SSC Journeyman
SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)

Group: General Forum Members
Points: 78 Visits: 420
Steve Jones - SSC Editor (12/21/2012)

Monitor is built to monitor and alert. That's it's focus. Some of the other products are more for digging in and troubleshooting. It depends on what's more important to you. I'd say test them, think about what you need, and then decide.


That's what I'm looking for. I think I'd like to learn and use MS SQL's tools to dig and troubleshoot.

Does anyone know how "heavy" it is on the monitored server? Is there anything that needs to be installed on the SQL server?
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36146 Visits: 18751
What tools? What are you thinking of?

The Management Data Warehouse will do this, but it's a lot of admin, IMHO.

Extended Events or Trace can help, but they are a little complex. Very low performance impact.

You can roll your own with queries to the performance counters, or alerts, but this is software development, and IMHO, while you might do some of this, a lot of the alerting and framework here that you build isn't cost effective compared with the cost of tools. Lots of experienced DBAs agree with me that it isn't worth maintaining your own tools overall, though all tools will take a little development to ensure they work for you.

There might be other tools to help here, but it really depends on your giving/developing more details on what you are trying to accomplish.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search