none
sql server 2012 AlwaysOn sys.dm_hadr_availability_replica_states role_desc sp_update_alert RRS feed

  • Question

  • Is it possible to get an alert when an AlwaysOn group goes into a state of RESOLVING?

    In the DMV "sys.dm_hadr_availability_replica_states", in the column "role_desc" when it says "RESOLVING" nothing can connect to nether the primary nor the replica, granted it is a short period normally around 5 seconds, but we want alerting on this.  The RESOLVING state is when it is deciding whether it should fail over and this is based on the number of errors that the cluster has seen at the OS level.  We are running Windows Server 8 and SQL Server 2012.  We have changed the default "Maximum failures in the specified period" from 2 to 3 and the "Period (hours)" from 6 to 4.  (in cluster admin, under roles you will find the AlwaysOn groups, right click and goto properties)

    PS:  If someone knows a monitoring tool that can do this with the correct template, I would like to hear from the vendor.

      sp_update_alert 

    Friday, April 19, 2013 2:07 PM

Answers

  • Duane --
     
    I believe you have erroneously posted your question in a public user forum dedicated to questions about Microsoft Project, a project management tool.  I would recommend that you repost your question in a public user forum dedicated to SQL Server 2012.  Hope this helps.
     

    Dale A. Howard [MVP]

    Friday, April 19, 2013 2:21 PM
    Moderator

All replies

  • Duane --
     
    I believe you have erroneously posted your question in a public user forum dedicated to questions about Microsoft Project, a project management tool.  I would recommend that you repost your question in a public user forum dedicated to SQL Server 2012.  Hope this helps.
     

    Dale A. Howard [MVP]

    Friday, April 19, 2013 2:21 PM
    Moderator
  • That will teach me to trust a Bing search.
    Friday, April 19, 2013 2:47 PM
  • Ha, funny!  :)
     

    Dale A. Howard [MVP]

    Friday, April 19, 2013 3:19 PM
    Moderator