• Steve Jones - SSC Editor (5/9/2011)


    Christian Buettner-167247 (5/9/2011)


    The answer does not sound right to me.

    For heaps, there are no page splits, therefore the only counter that gives me the answer for both, indexes & heaps, is the Pages Allocated/sec counter.

    While you are correct that page splits do not occur for heaps, it also means that there is no movement to new pages. This isn't pages used for data, the question asked for pages on which data is moved.

    Hi Steve, when the 2nd row from my example heap is updated, the data of the 2nd row actually is being moved to a new page.

    Best Regards,

    Chris Büttner