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 8:34 pm

    #1622208

    GilaMonster (6/7/2013)

    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.

    Thanks Gail, sounds like trying to dig around for a program to read the fragmentation is a moot point. Appreciate the feedack.

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀