Return
-
Title
SoSSE stops monitoring after several hours -
Description
Spotlight on SQL Server Enterprise (SoSSE) will stop monitoring after serveral hours; causing all SQL connections to turn red and error out. This has been occuring since we upgraded from 7.0 to 7.01. To get it working again we have to restart the Diagnostic Server.
-
Cause
Playback Database is corrupted, causing the following errors to occur in the adk.log:
PlaybackHistory - Deleting old playback data failed
-
Resolution
Drop and re-create the Playback Database, then restart the Diagnostic Server.
-
Additional Information
Before dropping the old Playback Database, you may also want to review SOL64550 for instructions on how to retain the old playback data:
https://support.quest.com/Search/SolutionDetail.aspx?id=SOL64550