Return
-
Title
Fragmented indexes alarm showing orange or red while there are no major fragmantations -
Description
While using the default set up for fragmented indexes alarm, Spotlight only shows a couple of large indexes over 1000 pages and with the average fragmentation being 1 and 0 percent, the product will not generate a script for it. However, the alert is coming up orange for medium. If drilled down to smaller indexes, these are fragmented. If any index is over 5% will this not be green on the home page. -
Resolution
WORKAROUND
none
STATUS
Waiting for fix in a future release of Spotlight on SQL Server Enterprise
-
Defect ID
SOSSE-3919