Dave Heavy Industries Dave Heavy Industries – blog


MS SQL Server – index fragmentation – amended

From http://wp.daveheavyindustries.com/2011/02/07/ms-sql-server-index-fragmentation/

Having had to use this on a very large database, I've made some small changes to the index fragmentation statistics script. this time to include table names (object_name) as well as database_name.


MS SQL Server – index fragmentation

Sometimes it doesn't make sense to rebuild all of your indexes as part of a maintenance plan. You may have mirroring running with large db tables, and your indexes may be several GB. As part of your maintenance schedule, I recommend manually finding fragmented indexes and rebuilding them yourself (or scripting this)

To do this you, you need to locate the indexes -- anything over 50% can be considered a problem.