The following error occurs when attempting to look at index fragmentation details from Spotlight SQL server home page:
Messages Component: Fragmented Indexes The following error occurred while collecting data Error 50000, Level 16, State 1, Procedure -, Line 148, Message: Error 8115, Level 16, State 6, Procedure -, Line 1, Message: Arithmetic overflow error converting float to data type numeric. [50000] [Error Code: 50000]. Table: Fragmentation by Index Occurred: <date and time>PM
WORKAROUND
1. Go to the Diagnostic server installation directory. By default it should be here:
\Agent\conf\Package\sqlserver_spotlight\
2. Backup existing “QS_FragmentationByIndex.sql” then replace it with the new one in the attachment.
3. Restart Spotlight Diagnostic Server service.
4. Connect to Spotlight.
STATUS
Issue fixed in the current release of Spotlight on SQL Server Enterprise. Latest version of Spotlight can be downloaded from here.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center