Return
-
Title
How to customize the rebuilt index option to select only those with a certain percentage of fragm -
Description
How to customize the rebuilt index option to select only those with a percentage of fragmentation
-
Cause
N/A
-
Resolution
WORKAROUND:
The detail on the native function for SQL 2005, which may be inserted to a LiteSpeed Maintenance Plan as a t-sql step is:
Check the avg_fragmentation_in_percent value in sys.dm_db_index_physical_stats.
http://msdn.microsoft.com/en-us/library/ms188917.aspx
STATUS:
Enhancement request has been submitted for possible implementationin afuture version of LiteSpeed -
Defect ID
CR68772