May 30, 2014 at 9:38 am
I have seen some of the other threads regarding this .. but I am looking for a good explanation for a vendor. We are running on sql server 2008r2 and we are running scripts that rebuild indexes based on fragmentation levels being higher than 20%.. however the vendor uses some queries using dbcc showcontig which is showing we have a couple of indexes that even though their fragmentation is very low (5-15%) the "scan density" (which isn't checked as it isn't part of the dmv's to my knowledge) is also very low (in the 30-50%) range. Can this be normal? We do use file groups with 2 files located on different drives in each group. Doing a rebuild of the index does "clean" the scan density.. but should this be necessary.. Should I modify the scripts that are using the dmv's for checking for reasons to rebuild indexes to start using the older dbcc showcontig? I guess I am looking for an "experts" response as to why we shouldn't care about scan density or an explanation to the contrary. Thank you very much for taking the time to read my post!
Jay
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply