Home Forums SQL Server 2008 SQL Server 2008 Administration Any Tool / Application to read SQL Server Database Fragramentation ? RE: Any Tool / Application to read SQL Server Database Fragramentation ?

  • June 7, 2013 at 3:23 pm

    #1622198

    sqlsurfing (6/7/2013)

    I wanted to see the internals if after the full index re-builds of all tables things are truly "de-fragmented"

    If you've rebuilt the indexes, then the indexes are about as defragmented as they're going to get. You don't need any tools to see index fragmentation, the index physical stats DMV shows that.

    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