Post reply

Page Splits

  • July 9, 2004 at 2:16 am

    #86149

    Hi,

    I want to check whether I have an issue with page splitting on a certain table and whether I have the fill factor set at the correct level.  Does anyone know of a method of measuring page splits for an individual table or index. i.e. with Profiler or something?

    Thanks

    Jamie

  • July 9, 2004 at 2:41 am

    #514007

    I don't know if thats possible, but, perhaps you could write a little test application that simulates the expected load and environment on that table independently of the others,  and then use the Perfmon page splits per second counter to monitor various configurations.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply