Post reply

Required Database Monitoring Tool

  • July 10, 2019 at 6:46 am

    #3661459

    Hi

    We have 10 SQL Server Instance and we have implemented database replication between 7 instances. We need to monitor replication status data latency, Instance status, database status etc.. so if anyone using some tool for monitoring db replication please advice on this.

     

    Thanks

    Harsha

  • July 10, 2019 at 10:15 am

    #3661498

    Most of the major tools have mechanisms for monitoring replication in one way or another. Redgate Software's SQL Monitor (I work for Redgate by the way) uses custom metrics to get the job done. Here is an article on a series of metrics and alerts. Here's a published custom metric. You can not only monitor replication, but pretty much any other aspect of SQL Server using SQL Monitor.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • July 10, 2019 at 11:42 am

    #3661529

    Hi

     

    Thank you very much for your reply.

    We have 7 instances configured replication, we want to check that 7 instances replication status in one dashboard, hope using Red Gate SQL Monitoring tool we can not reach our requirement.

     

    Thanks

     

     

  • July 10, 2019 at 4:52 pm

    #3661654

    Yep. It'll do exactly what you're asking. All seven instances in one view.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • July 10, 2019 at 5:28 pm

    #3661667

    I DON'T work for RedGate but I do use SQL Monitor to monitor 15 instances and I can tell you I couldn't go back to pre RedGate days.  I'm not saying there aren't other great tools out there but just having anything makes a huge difference.  Problem resolution time is cut down tremendously.  Just this week I had an application timing out and one of my developers ask me to check if there were any issues with the DB.  Within 30 seconds I had my answer.  Another user had run a real ugly resource intensive query.  I was able to see the exact query and who ran it.  Was able to to email said user with a copy of their query and told what he had done wrong and why.  FYI - he used a leading wildcard search on a very large table.  i.e. WHERE column = '%something%'  So kiss any indexes goodbye...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

  • July 10, 2019 at 10:13 pm

    #3661767

    What are you looking to check with  "we want to check that 7 instances replication status in one dashboard"?

    If you want just a replication dashboard, you can build some things in SQL Monitor with a report, choosing replication metrics for display from the machines. You can add custom metrics as well to measure what you want.

  • July 11, 2019 at 6:50 am

    #3661851

    Hi All

    Thank you very much for all comments.

     

    Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

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