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

SQL Monitor Expand / Collapse
Author
Message
Posted Tuesday, December 18, 2012 8:51 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 24, 2014 6:14 AM
Points: 65, Visits: 404
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!
Post #1397859
Posted Tuesday, December 18, 2012 8:29 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, November 24, 2014 5:46 AM
Points: 4,029, Visits: 7,172
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"
Post #1398122
Posted Tuesday, December 18, 2012 11:13 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:16 AM
Points: 2,840, Visits: 3,983
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
Post #1398185
Posted Thursday, December 20, 2012 8:05 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, November 14, 2014 1:47 AM
Points: 19, Visits: 299
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.
Post #1399153
Posted Friday, December 21, 2012 9:15 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 10:36 AM
Points: 31,362, Visits: 15,823
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
Post #1399476
Posted Friday, December 21, 2012 9:18 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 10:36 AM
Points: 31,362, Visits: 15,823
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
Post #1399481
Posted Friday, December 21, 2012 12:00 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 24, 2014 6:14 AM
Points: 65, Visits: 404
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?
Post #1399544
Posted Friday, December 21, 2012 12:45 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 10:36 AM
Points: 31,362, Visits: 15,823
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
Post #1399559
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse