locked
SQL replication monitoring RRS feed

  • Question

  • Hi,

    Does anyone have a set of rules or monitors written for SQL replication monitoring?

    Regards,

    Dhanraj

    Wednesday, July 20, 2011 11:25 AM

Answers

  •  

    Hi,

     

    Please try the SQL Server Management Pack and see if it helps:

     

    SQL Server Monitoring Management Pack

    http://www.microsoft.com/download/en/details.aspx?id=10631

     

    In addition, regarding monitoring SQL replication, please also refer to the following post:

     

    All About Automatically Monitoring Replication Agent Failures

    http://blogs.msdn.com/b/repltalk/archive/2010/05/09/all-about-automatically-monitoring-replication-agent-failures.aspx

    Please see the section “About SCOM monitoring for SQL replication”.

     

    Hope this helps.

     

    Thanks.


    Nicholas Li - MSFT
    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Friday, July 22, 2011 7:48 AM
  • Hi Dhanraj,

     

    in this blog post from Cameron fuller you can find information about enabling sql replications monitors

    http://blogs.catapultsystems.com/cfuller/archive/2010/11/10/enabling-sql-replication-monitoring-%E2%80%93-what-to-expect-in-the-replication-views-in-opsmgr.aspx

     

    Hope it helps

    Greatings Roelkn


    The Difficult takes time, the impossible just a little longer. my twitter @Roelkn
    Friday, July 22, 2011 9:13 AM

All replies

  •  

    Hi,

     

    Please try the SQL Server Management Pack and see if it helps:

     

    SQL Server Monitoring Management Pack

    http://www.microsoft.com/download/en/details.aspx?id=10631

     

    In addition, regarding monitoring SQL replication, please also refer to the following post:

     

    All About Automatically Monitoring Replication Agent Failures

    http://blogs.msdn.com/b/repltalk/archive/2010/05/09/all-about-automatically-monitoring-replication-agent-failures.aspx

    Please see the section “About SCOM monitoring for SQL replication”.

     

    Hope this helps.

     

    Thanks.


    Nicholas Li - MSFT
    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Friday, July 22, 2011 7:48 AM
  • Hi Dhanraj,

     

    in this blog post from Cameron fuller you can find information about enabling sql replications monitors

    http://blogs.catapultsystems.com/cfuller/archive/2010/11/10/enabling-sql-replication-monitoring-%E2%80%93-what-to-expect-in-the-replication-views-in-opsmgr.aspx

     

    Hope it helps

    Greatings Roelkn


    The Difficult takes time, the impossible just a little longer. my twitter @Roelkn
    Friday, July 22, 2011 9:13 AM
  • Hi Nicholas,

    I ve tried those blogs.

    The mistake was i was trying to add a EventDescription field that could match the alert description. Now added only for the Event ID's.

    @Roelkn - The blog is helpful in enabling replication monitoring.

     

    Thanks a lot for your replies..

    Tuesday, July 26, 2011 3:27 PM
  • Hi Nicholas,

    What event source do i need to specify as only giving event ID's in an alert generating rule is not helpful picking up the alert.

     

    Thanks.

     

    Thursday, July 28, 2011 2:22 PM