tsql so I can remember in the future.
declare @db_id int
declare @object_id int
set @db_id = DB_ID('EMR')
set @object_id = 0
select db_name(@db_id) as [database], object_id, object_name(object_id, @db_id) as object_name,
index_id,
avg_fragmentation_in_percent,
page_count
from sys.dm_db_index_physical_stats(@db_id, null, null, null, 'LIMITED')
where page_count > 1000
and
avg_fragmentation_in_percent > 35
order by avg_fragmentation_in_percent desc
database object_id object_name index_id avg_fragmentation_in_percent page_count -------------------------------------------------------------------------------------------------------------------------------- ----------- -------------------------------------------------------------------------------------------------------------------------------- ----------- ---------------------------- -------------------- EMR 1091587027 ARCH_HXDIAGNOSIS 1 35.2092352092352 1386
