October 3, 2014 at 11:36 am
When was the last time statistics were updated? Sounds like a bad plan cached on the secondary.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 3, 2014 at 12:51 pm
According to microsoft "For availability groups, statistics that are created and maintained on the primary databases are automatically persisted on the secondary databases as part of applying the transaction log records"
I ran both SP on the Primary and Secondary with Statistics IO on....I got back that same information on disk activity.
CPU time was higher on the Slow node. I increased Mad degree Parallelism from 4 to 12 and SP came back just as fast as the Primary.
Had the server team check hardware and no errors.
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply