DBCC SHOWCONTIG - m
Check SQL Server a specified database index fragmentation
(You can learn more about how to verify the fragmentation in SQL Server 2000 on this Web site.) Even if the indexes are properly created, they tend to lose effectiveness over time due to the fragmentation that occurs on the table throughout the. Using the dynamic management function _db_index_physical_stats will help you detect fragmentation in a specific index or all indexes on a table or indexed view. In the case of partitioned indexes, this DMV will also provide fragmentation information for each partition. The resulting fragmentation (free space on pages) will lead to improper usage of memory when using search arguments to scan for a particular dataset. Whats New in SQL Server 2005? The DBCC SHOWCONTIG statement has been replaced.
For example, when a table with a variable-length column is updated to a larger size in that page and can no longer fit, SQL Server creates a forwarding pointer in that page.
Sql server 2000 index fragmentation report
You can use SELECT INTO to catch the entire result set. There is no need to use dynamic string execution to interpret the results. SELECT INTO #tbl_Fragmentation FROM _db_index_physical_stats (DatabaseID, TableId, IndexId, NULL, Mode Please note that the Scanning Mode of the above.
Written by: IanMFT
4,7 / 5 stars