Blog Post

SQL Server Blog
5 MIN READ

AlwaysOn: Challenges with statistics on ReadOnly database, Database Snapshot and Secondary Replica

Sunil_Agarwal's avatar
Sunil_Agarwal
Icon for Microsoft rankMicrosoft
Mar 23, 2019
First published on MSDN on Dec 22, 2011 I am sure you all have dealt with situations when the statistics on one or more columns is either missing or not up-to date. When us...
Updated Mar 23, 2019
Version 2.0
sqlserverstorageengine
Vivek_Vijay_Ghag's avatar
Vivek_Vijay_Ghag
Copper Contributor
Apr 20, 2020

Hi Sunil,

 

Is there any fix for above issue ?

We have a Always On environment on SQL 2017 and similar issue is being reported by application team when they run scheduled jobs on secondary replica which is in Async commit.