For SQL Server 2005 instances only with compatibility level set to '90', collection LiteSpeed activity failed, error SYS datetime is not a recognized a function name {195}.
Spotlight Message:
WORKAROUND
Please replace the attached file as follows:
1. The script QS_LiteSpeed.sql should be placed into {DS dir}\Agent\conf\package\sqlserver_spotlight\2005
Where {DS dir} is the Diagnostic Server installation directory.
2. A Diagnostic Server restart is not required.
STATUS
Waiting for fix in a future release of Spotlight on SQL Server Enterprise.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center