WORKAROUND:
The alarm means Diagnostic Server used more than 90% of its allocated memory of diagnostic server.exe. Spotlight will continue to improve its memory usage from version to version.
As a workaround, please increase the memory limit for Diagnostic Server if there is sufficient spare memory on the host. Follow the below steps to increase memory limit for Diagnostic Server:
1. Backup the file {DS dir}\Agent\bin\SpotlightDiagnosticServer.ini
2. Edit the file
3. Change "-Xmx2048m" to "-Xmx4096m"
4. Save the file
5. Restart the Diagnostic Server service.
STATUS:
Enhancements have been implemented in the latest version of Spotlight on SQL Server Enterprise and can be downloaded
here.
