Post reply

SQL Server 2014 Always On

  • September 18, 2018 at 5:07 am

    #372803

    Good day,
    I am still very green with Always On and its Availability Groups, so bear with me. Our HA is running on a cluster with automatic failover enabled. I would like to know when the SQL Server Instance has failed over to its second node ? 

    Any ideas ?

    Regards.
    Lian

  • September 18, 2018 at 5:27 am

    #2006094

    In Management Studio, go to the AG and right-click on it, then select Show Dashboard (make sure you're on the Primary replica). Then at top right there's an option to click on View AlwaysOn Health Events. Sort by date. 

    Warning: it's not all that user-friendly! You can also check the error log.

  • September 18, 2018 at 6:48 am

    #2006108

    thx

Viewing 3 posts - 1 through 2 (of 2 total)

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