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 12»»

An In-Depth Examination of Red Gate SQL Monitor Expand / Collapse
Author
Message
Posted Monday, February 14, 2011 12:01 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 18, 2014 7:02 AM
Points: 1,140, Visits: 701
Comments posted to this topic are about the item An In-Depth Examination of Red Gate SQL Monitor

--
Adam Machanic
SQL Server MVP
SQLblog.com: THE SQL Server Blog Spot on the Web
Post #1063318
Posted Monday, February 14, 2011 3:28 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:41 AM
Points: 1,148, Visits: 1,070
Nice one, Adam. I'm just getting round to using SQL Monitor after winning a copy from Red Gate. My colleagues still find it a bit freaky when I say stuff like, "How's that long running query working out for you?" - I don't think they like the Big Brother of it all
Post #1063387
Posted Monday, February 14, 2011 7:12 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:08 AM
Points: 5,975, Visits: 12,878
does it focus down on individual queries as the cause of high resource usage, show query plans, suggest possible improvements?

You say servers must be defined by physical name which is obviously an issue with clusters, but the SSC servers being monitored are clustered? Is this a case then of monitoring all the nodes in the cluster but having to know which node is currently active?



---------------------------------------------------------------------

Post #1063501
Posted Monday, February 14, 2011 7:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 18, 2014 7:02 AM
Points: 1,140, Visits: 701
george sibbald (2/14/2011)
does it focus down on individual queries as the cause of high resource usage, show query plans, suggest possible improvements?


No. It's more of a server-wide picture, with occasional deeper insight when certain events hit. As I mentioned in the article, I'm very much looking forward to additional enhancements.



You say servers must be defined by physical name which is obviously an issue with clusters, but the SSC servers being monitored are clustered? Is this a case then of monitoring all the nodes in the cluster but having to know which node is currently active?


I don't know if the SSC servers are clustered or not. Yes, you can put both physical names in, but AFAIK the tool doesn't tell you which node is active.



--
Adam Machanic
SQL Server MVP
SQLblog.com: THE SQL Server Blog Spot on the Web
Post #1063540
Posted Monday, February 14, 2011 8:16 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:28 AM
Points: 1,100, Visits: 4,898
I am just starting to set up SQL Monitor to monitor a clustered server, so I'll see if I get the same problems you had with registering the server.
Post #1063559
Posted Monday, February 14, 2011 8:37 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 9:30 AM
Points: 33,062, Visits: 15,177
Adam Machanic (2/14/2011)


You say servers must be defined by physical name which is obviously an issue with clusters, but the SSC servers being monitored are clustered? Is this a case then of monitoring all the nodes in the cluster but having to know which node is currently active?


I don't know if the SSC servers are clustered or not. Yes, you can put both physical names in, but AFAIK the tool doesn't tell you which node is active.



Yes, the SSC servers are clustered. No idea which one is active as of now, but I'll ask if the tool shows this.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1063579
Posted Monday, February 14, 2011 8:46 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, January 10, 2014 7:20 AM
Points: 175, Visits: 723
The SSC cluster is an active/active cluster, and SQL Monitor is monitoring both of them with ease. Node 1 runs the SSC databases, and node 2 runs the Simple-Talk databases.

Brad M. McGehee
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.bradmcgehee.com
Post #1063586
Posted Monday, February 14, 2011 8:48 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 18, 2014 7:02 AM
Points: 1,140, Visits: 701
bradmcgehee@hotmail.com (2/14/2011)
The SSC cluster is an active/active cluster, and SQL Monitor is monitoring both of them with ease. Node 1 runs the SSC databases, and node 2 runs the Simple-Talk databases.


Makes sense. So the situation described in the article only applies to active/passive clusters.



--
Adam Machanic
SQL Server MVP
SQLblog.com: THE SQL Server Blog Spot on the Web
Post #1063590
Posted Monday, February 14, 2011 9:41 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:08 AM
Points: 5,975, Visits: 12,878
well if you are pointing at physical server names you still need to know which node is supporting which instances or you might wonder why CPU usage just fell through the floor

---------------------------------------------------------------------

Post #1063631
Posted Monday, February 14, 2011 9:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, February 22, 2014 8:11 AM
Points: 6, Visits: 236
How would you compare SQL Monitor to SQL Sentry? The one thing I do not like about SQL Sentry is that it is not web based.
Post #1063634
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse