• GilaMonster (6/7/2013)


    If your indexes have just been rebuilt, then you probably don't have much logical fragmentation.

    Red Gate's got a tool to show you index fragmentation. Free tool last time I checked, but it just checks the same DMVs you can.

    Thanks Gail, I've been struggling with slow backups after deleting nearly 40%-50% of our database and rebuilt all indexes. (I posted a question awhile back - http://www.sqlservercentral.com/Forums/Topic1449898-391-2.aspx#bm1450875) I decided to re-visit it again. I wanted to see the internals if after the full index re-builds of all tables things are truly "de-fragmented"

    I haven't figured out why, a lot of nice people chimed in and gave some suggestions and recommendations, but unfortunately nothing that helped. I probably am missing something, either not asking the right question to narrow it down. I did have another idea... I dont' have the diskspace (and time yet...) for a test server, but working on maybe move everything into new Filegroup and datafiles.

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