We have a database in primary DC around 15 TB with partitioned tables with largest one around 7 TB.
To avoid users from reporting a LS set up was done for above database in different DC where the LS restore job runs once nightly.
on Primay- update stats and update stats AYNC are both set to True and hence reflected the same on secondary. I am not sure why someone kept both enabled and is that how it should be?
Now on secondary, i see lots of blocking occurring when a SELECT query runs from users results in select statman statement for auto update stats for that read only database.
I am not able to get why there would be one when auto update async is enabled?
Also, will the update stats done on primary (once a week) be restored during LS restore? if not, whats the better way to run update stats on secondary database involved in LS standby mode, may be to run daily for better select performance out there?