Post reply

Ensure that SSRS is Working while Using Availability Groups

  • November 17, 2020 at 12:00 am

    #3808482

    Comments posted to this topic are about the item Ensure that SSRS is Working while Using Availability Groups

  • November 17, 2020 at 1:59 pm

    #3808675

    Thank you, very interesting.

    Going on a bit longer, what about jobs created by SSRS subscriptions in AON AGs? Are they created evenly in all nodes including the necessary logic to run only in the instance where the primary replica of the SSRS DBs is?

    I'm missing a SQL Agent clustered service besides the AlwaysOn resource in the cluster role...

  • November 17, 2020 at 7:17 pm

    #3808896

    Yep, in addition to what was already mentioned in the article the SQL agent jobs related to a subscription will also need to be kept in sync between replicas. I think Microsoft addresses this in a MS doc article by basically stating the SSRS service needs to be restarted after a failover occurs. That way all associated roles and agent jobs get created if not already in place.

     

    I think a better solution would be is SSRS could be more AG-aware and be able to do that without DBA intervention.

    Joie Andrew
    "Since 1982"

  • November 25, 2020 at 8:37 am

    #3813793

    This reply has been reported for inappropriate content.

    I am really happy to say that, It is a very interesting post to read walgreenslistens.

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

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