Post reply

Page Splits /Sec

  • December 12, 2013 at 12:06 am

    #281190

    Hi all

    Regarding the Page Splits /Sec counter, this tracks the amount of page splits per second as well as the amount of new pages allocated per second, correct?

    If that's the case, what does the Pages Allocated/sec counter indicate and why, on my instance would it be more than the Page Splits /Sec counter?

    Thanks

  • December 12, 2013 at 6:05 am

    #1672914

    This might help you....

    http://www.quest.com/techbrief/sql-server-perfmon-counters-poster811635.aspx

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • December 12, 2013 at 6:10 am

    #1672920

    Thanks for the link, it doesn't help however.

    I'm looking for the difference between the 2 counters.

  • December 12, 2013 at 7:28 am

    #1672952

    Forgive my stab at this, but page splits happen when data cannot fit in the page it's aiming for and a new page has to be allocated if I remember correctly. that being said, all page splits cause a page allocation, but not all page allocations are inherently splits. Can someone with a bit more of a background check this for me?

    .

  • December 12, 2013 at 11:55 pm

    #1673167

    So all page splits cause a page allocation but not all page allocations stem from a page split?

  • December 13, 2013 at 6:49 am

    #1673238

    That's my understanding of it. A page split is when a record cannot fit on the page it's designated for. Not all page allocations come from splits. Page splits are not always bad. Here's a good link[/url] on the subject.

    .

  • December 13, 2013 at 6:53 am

    #1673240

    And another good article - http://www.sqlskills.com/blogs/paul/tracking-page-splits-using-the-transaction-log/

    And when you are done with that one if you want to read more on page splits and page allocations search Google for "Paul Randal Page Splits" or "page allocations".

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 7 posts - 1 through 6 (of 6 total)

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