Return
-
Title
Receiving alarm, "SQL Server Connection Failure - The SQL query has timed out" -
Description
Spotlight randomly shows the alarm:"Monitored Server - SQL Server Connection Failure: Cannot connect to SQL Server instance '<instance_name>' : The SQL query has timed out."However, at the time of the alarm, the SQL Server is up and running fine. -
Cause
Per the Support Bundle, there are JVM out of memory messages and this can be due to the fact that the Diagnostic Server is too busy and it shows the services attempts to restart several times. -
Resolution
SOLUTION:Increase the total system RAM and then increase the JVM memory. (For example, increase the system RAM to 12 GB, then increase the JVM memory to 8 GB.)How to increase JVM Memory for Spotlight:1. Stop Diagnostic Server service.2. Edit the 'C:\Program Files\Quest Software\Diagnostic Server\Agent\bin\SpotlightDiagnosticServer.ini' file.3. Change the value within from "-Xmx6144m" to "-Xmx8192m", this is to increase JVM from default 6 GB to 8 GB.4. Start Diagnostic Server service.