August 31, 2016 at 3:05 am
How to update stats to a database which is in always on group ?
August 31, 2016 at 6:47 am
As far as I know, you can only update the statistics on the primary server and it will also update the statistics on the secondary replica. I don't think that you can modify the statistics on the secondary replica directly. Because the work load on primary and secondary replicas can be different, the server can create temporary statistics for the secondary replica that don't exist on the primary database. In such case you can delete the temporary statistics but again, there is no way to update it or to create it on you own.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply