reduce page splits

Posted on 2011-04-28
Last Modified: 2012-06-22
I went to link and still dont understand how to reduce page splits
is there an easier way

Page splits are currently accounting for 100% of all new page allocations.

It is recommended that the fill factor be lowered on indexes that are experiencing a high number of page splits. This will result in better insert and update performance.
Learn more about:
Question by:rgb192
    LVL 13

    Expert Comment

    It seems that you are not clear about what a page-split is, that why you are worried about it. In your case, I think that there is no issue with page splits.

    When you insert data to a table, it page split occurs very often (or a new page is allocated) then it is a problem. A new page is allocated only when there is not enough space on some existing page. And while inserting record into a table, if a new page is allocated it will be accompanied by a page split.
    Page split means that when a new page is allocated, half of data from some existing page is shifted to the new page. It is quite common during a new page allocation.
    LVL 9

    Expert Comment

    What is your OS and It is 32/64 bit?
     What is your RAM size in server?

    Author Comment

    server windows server 2008 64 bit with 8gig of ram but low cpu

    my computer is freezing
    LVL 9

    Accepted Solution

    you should have faster CPU for this.

    OK, try rebuild your indexes in a regular basis and that will solve your problem.

    Author Closing Comment


    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Suggested Solutions

    If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    This video discusses moving either the default database or any database to a new volume.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now