What functions of tools do you use for managing index fragmentation?
DBCC?
I am working through MS Press SQL 2005 book and it mentions the sys.dm_db_index_physical_stats function? It then give an example of code which is very involved.
You can use it or 'dbcc showcontig' to check index fragmentation.
From BOL:
quote: Important: This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use sys.dm_db_index_physical_stats instead.
Ola, Thank you so much. I read that article and it helped a lot. I was able to reorganize quite a few indexes. I reorganized the example query on that page to work for my database. However, upon running it, the results came back with some highly fragmented indexes, but null values in the name column. Is there another way to find out which indexes these are?
Index Fragmentation
Posted - 06/22/2008 : 18:59:45
