Home Forums SQL Server 2005 Administering Performance issue due to index fragmentation. RE: Performance issue due to index fragmentation.
Richard M.
SSCertifiable
Points: 7401
More actions
April 23, 2010 at 9:41 am
#1156978
You might want try running that dmv with the 'LIMITED' option:
FROM sys.dm_db_index_physical_stats (DB_ID(' DB '),OBJECT_ID(' Table'A' '),NULL, NULL, 'LIMITED')
as it will have better performance, specially if it is a big table.
_______________________________________________________________________For better assistance in answering your questions, click here[/url]