Skip navigation

Log in to create and rate content, and to follow, bookmark, and share content with other members.

AnsweredAssumed Answered

MS SQL DB Replication Monitoring

Question asked by Roushan on Apr 12, 2018
Latest reply on Jul 23, 2018 by Roushan

Like • Show 0 Likes0
Comment • 4

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!

No one else has this question

Outcomes

4 Replies

Phani Devulapalli Apr 16, 2018 12:05 AM
Mark Correct
Correct Answer
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
Like • Show 0 Likes0
Actions
- Roushan @ Phani Devulapalli on Apr 16, 2018 6:55 PM
  Mark Correct
  Correct Answer
  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
  Like • Show 0 Likes0
  Actions
  - Phani Devulapalli @ Roushan on Apr 16, 2018 10:58 PM
    Mark Correct
    Correct Answer
    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
    Like • Show 1 Like1
    Actions
    - Roushan @ Phani Devulapalli on Jul 23, 2018 7:29 PM
      Mark Correct
      Correct Answer
      This was helpful.
      thank you!
      Like • Show 0 Likes0
      Actions

Recommended Content