andrew4582

Index Physical Stats

Dec 27th, 2010
278
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.50 KB | None | 0 0
  1. DECLARE @table_name varchar(255)
  2. SET @table_name = 'Contact2'
  3.  
  4. SELECT
  5.     s.[OBJECT_ID],OBJECT_NAME(s.[OBJECT_ID]) as tablename
  6.     ,si.name as indexname
  7.     , s.avg_fragmentation_in_percent
  8.     , s.fragment_count
  9.     , s.page_count
  10.     ,s.avg_fragment_size_in_pages
  11. FROM sys.indexes si inner join sys.dm_db_index_physical_stats (DB_ID(), null, null, null, null) s
  12.   on si.object_id = s.object_id and si.index_id = s.index_id
  13. --WHERE OBJECT_NAME(s.[OBJECT_ID]) = @table_name
  14. ORDER BY s.avg_fragmentation_in_percent desc
Advertisement
Add Comment
Please, Sign In to add comment