An In-Depth Examination of Red Gate SQL Monitor

  • Adam Machanic

    SSCoach

    Points: 15259

    Comments posted to this topic are about the item An In-Depth Examination of Red Gate SQL Monitor

    --
    Adam Machanic
    whoisactive

  • Michael Lysons

    SSCertifiable

    Points: 6299

    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 😀

  • george sibbald

    SSC Guru

    Points: 104200

    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?

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

  • Adam Machanic

    SSCoach

    Points: 15259

    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
    whoisactive

  • jts2013

    Hall of Fame

    Points: 3116

    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.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 714067

    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.

  • Brad McGehee

    SSCertifiable

    Points: 5272

    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
    DBA

  • Adam Machanic

    SSCoach

    Points: 15259

    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
    whoisactive

  • george sibbald

    SSC Guru

    Points: 104200

    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 🙂

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

  • Ian D-387508

    SSC Veteran

    Points: 284

    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.

  • priya.sinha

    SSC-Addicted

    Points: 497

    george sibbald (2/14/2011)


    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 🙂

    Hi,

    This information is available under Overviews in SQL Monitor. For a cluster, there are various Overviews available at virtual cluster, nodes and sql instance level. If you look at view which is available at the virtual cluster level, you should be able to see the list of all the resoures and the node which is currently supporting it. This is copied for SQL Monitor UI:

    Name Status Active node Resource group Resource type

    Cluster Disk 1 Online sqlcluster2 Cluster Group Physical Disk

    SQL Server Online sqlcluster1 SQL Server (MSSQLSERVER) SQL Server

    Thanks,

    Priya

  • george sibbald

    SSC Guru

    Points: 104200

    thanks

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

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 714067

    SQL Sentry's Performance Advisor is really a performance tuning tool, not really a monitoring tool. They perform separate functions.

  • ammarany

    Grasshopper

    Points: 21

    A very well briefly written post, with lots of useful information.

    tnx

    Extensive server monitoring software by Servers Alive, high performance system and network monitoring software info: http://www.woodstone.nu/salive

Viewing 14 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply