Post reply

Page Split

  • June 11, 2017 at 3:21 am

    #337552

    Hi Experts,

    We are observing heavy page split on one table which have frequent Insert and Update. Tables stores vehicle information like route, whether its entering different office locations(update) etc. I believe this normal as the table needs to be updated and inserted with data.

    Is there anything I need to look at which can help reduce the page split?  Two non-clustered index exists and have fill factor 0. These two index gets heavy fragmented and are candidates of defragmentation every week.

    Thanks in Advance.

  • June 11, 2017 at 5:03 am

    #1946327

    Reduce the fill factor slightly. Test and repeat until acceptable.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 12, 2017 at 12:12 am

    #1946356

    GilaMonster - Sunday, June 11, 2017 5:03 AM

    Reduce the fill factor slightly. Test and repeat until acceptable.

    Thanks Gail.

    Will reduce to 80% and will check.

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

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