Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TessZA
Starting Member
7 Posts |
 Posted - 2009-02-19 : 03:15:16
|
| HiI am trying to find the physical index fragmentation % in a dynamic system view. I can however only find the logical fragmentation. In "sys.dm_db_index_physical_stats", the "avg_fragmentation_in_percent" is the same as the Logical Scan Fragmentation when using "DBCC SHOWCONTIG (TableName) with all_indexes"Is there a dynamic view where I can see the "Extent Scan Fragmentation" as shown when running "DBCC SHOWCONTIG (TableName) with all_indexes"?Tx |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-19 : 12:11:47
|
| I guess not. Both are External fragmentation and measures out-of order extents. Reason why SQL 2005 didn't include is that the number is meaningless when indexes span multiple files. |
 |
|
|
|
|
|
Physical index fragmentation