2

Recently I caught a massive page-split spike on an AlwaysOn Secondary instance that was not mimicked in any way by the active primary. I'm interested in what might cause this on a readable secondary since everything is "read-only". enter image description here

Improve this question
3
  • 1
    Did you enabled your secondary replica for read-only workload? Why am I asking? See this.
    – SqlWorldWide
    Commented Apr 28, 2017 at 21:30
  • I did, but I would expect the extra row version space to impact the primary and secondary equally .
    – vesuvious
    Commented Apr 29, 2017 at 23:21
  • I agree with what you said. Few things to consider in perfmon you do not know what database the splits r happening or kind of split? If you do not have XE setup(more targeted) or read the logs you will get to the bottom of this. 2 resources to consider. First one and 2nd one. There was a blog by Greg LInwood but I cant find it. [This](sqlblog.com/blogs/michael_zilberstein/archive/2009/02/05/… is also useful.
    – SqlWorldWide
    Commented May 1, 2017 at 12:28

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.