DX Infrastructure Manager

Expand all | Collapse all

MS SQL DB Replication Monitoring

  • 1.  MS SQL DB Replication Monitoring

    Posted 04-12-2018 03:16 PM

    Hi-

     

    We are facing a lot of issues because of DB stuck problem during replication.

     

    What are possible way to monitor this DB replication failure using Nimsoft. Please suggest.

     

    Thanks!



  • 2.  Re: MS SQL DB Replication Monitoring

    Posted 04-15-2018 08:05 PM

    We had these issues too and the easiest way we could figure out monitoring replication is by looking at the event logs. There are a standard set of events which are logged related to replication, use the ntevl probe to set up alerts the once you need 

     

    Use Alerts for Replication Agent Events | Microsoft Docs 

     

    Errors and Events Reference (Replication) | Microsoft Docs 



  • 3.  Re: MS SQL DB Replication Monitoring

    Posted 04-16-2018 02:56 PM

    Hello Phani-

     

    Thanks for sharing this.

     

     

    As both links has a lot ID and MSG -can you advise which one I shall use?

     

     

    Thanks!

     

    RoushanK



  • 4.  Re: MS SQL DB Replication Monitoring

    Posted 04-16-2018 06:58 PM

    Please pass them by your SQL Admin and identify which once they would be interested in receiving the alerts . They should be able to better advice 



  • 5.  Re: MS SQL DB Replication Monitoring

    Posted 07-23-2018 03:29 PM

    This was helpful.

    thank you!