Spotlight Fragmentation Index shows a yellow triangle with the following error:
Before Spotlight 11.5, the message would be...
Collection 'Fragmentation Overview' failed : Collection 'Fragmentation by Index' failed : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. : The wait operation timed out [0xFFFFFFFE]
From Spotlight 11.5 and onward, you will see...
Monitored Server - SQL Server Collection Execution Failure M/DD/YYY H:MM:SS Collection 'Fragmentation Overview' failed : Collection 'Fragmentation by Index' failed : The SQL query has been executing for longer than its timeout limit but has not timed out. It may be hung.
Even though changes to the Fragmentation Index collection has been made to Spotlight on SQL Server Enterprise 11.6, the query to get Index Fragmentation can potentially be a long running query and still time out if the monitor server is busy.
1. Try to run it now to see if you do get data. Do so by changing the Index Fragmentation collection schedule.
a. Go to "Configure | Scheduling"
b. In the top drop down, change from “Factory Setting” to the SQL Server with the issue
c. Look for the schedule "Fragmentation Overview" and click on the square icon next to it for the pop-up window
d. Uncheck "Factory Settings" and click on "at 4:15 AM every day"
e. Change to 1 Minute and if data does come back than we know maybe 4:15 AM is not an ideal time to run this
2. Once you have determined that 4:15 AM is not a good time to run the this collection, you can either guess, with trial and error, other times to run the collection or run it on intervals. If choosing to run the collection on intervals, make the times between the intervals hours long. For example, maybe 4 or 8 hour intervals.
The last version with the Fragmentation Index collection revision maybe downloaded from Support Link: https://support.quest.com/spotlight-on-sql-server-enterprise/download-new-releases
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center