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:
C:\Program Files\Quest Software\Diagnostic Server. Then go to below subfolder
\Agent\conf\Package\sqlserver_spotlight\<sql server version>
2. Backup existing "QS_GeneralDBStats.sql" file then replace it with the new one in the attachment.
3. Restart Spotlight Diagnostic Server service.
STATUS:
Issue fixed in the current release of Spotlight on SQL Server Enterprise.
© ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center