Assume that you use Microsoft SQL Server 2012 Always On Availability Groups. After statistics are updated by using the FULLSCAN option on the primary replica, the statistics on the secondary replica become stale or out-of-date. When you run a query on the secondary replica, a bad query plan might be used. This causes slow queries.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Artikelnummer: 4013236 – Letzte Überarbeitung: 21.03.2017 – Revision: 12