Failover happens almost immediately, but an application connecting to several databases on the server runs WAY slower (Queries return in 4 minutes compared to 30 seconds).

The hardware and software on both is the same, both are patched and updated to the latest version of 2017. I have updated statistics too.

Any other suggestions as to why? Or how to troubleshoot?

  • Are you sure? I think statistics are replicated to secondary nodes. Take a look at this article: sqlshack.com/…
    – MBuschi
    May 25, 2022 at 6:26
  • @MBuschi Yep the last part of statement was not correct. Yes the bad query behavior can be due to outdated stats and yes stats are moved.
    – Shanky
    May 25, 2022 at 8:02
  • Anyway it's hard to guess with so few details. Can you compare and post execution plans of a query runned on both nodes?
    – MBuschi
    May 25, 2022 at 19:57


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.