AlwaysOn Failover Execution Cache

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  March 3, 2020 at 5:28 pm

  #3730646

  Hello

  I would like to know on the event of a SQL Server AlwaysOn failover, what is the effect of the query performance? How long it takes to generate the execution cache as the existing queries running in the primary node will not go to Stand by node.

  Thanks.

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  March 4, 2020 at 6:10 pm

  #3730996

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.