Home Forums SQL Server 2008 SQL Server 2008 Administration Index Fragmentation and Performance RE: Index Fragmentation and Performance

  • August 10, 2012 at 1:36 pm

    #1524643

    GilaMonster (8/10/2012)

    pooyan_pdm (8/8/2012)

    And about the update I don't know what you think of a index key update but it' effects on page splits and fragmentation is the same as another insert.

    An update can only cause page splits in an index if it increases the size of the columns used as key or include. That's null-> non-null or increasing the amount of data in a variable length column.

    Thanks

    Regarding tracking page-splits, is this represented by the leaf_allocation_count in the sys.dm_db_index_operational_stats DMV?

    Thanks