The Spotlight Diagnostic Server is the data collection engine of Spotlight. A Windows Service that calls the SpotlightOOPCollector.exe program to collect data from monitored hosts and displays data on the Spotlight Client application. A sluggish server or application can be due to a CPU or memory hog such as the Spotlight Diagnostic Server. Why the sudden change of behavior? Let us look at a few possibilities:
- Spotlight was upgraded
- Evaluate and compare the changes between the previous and current versions.
- See Release Notes and KB 325056 article for the changes and new features of the latest and previous releases.
2. Spotlight was migrated to a new server
- Evaluate and compare the available resources and the running processes on the new server to the previous one.
- See System Requirements of the latest release.
Changes to the configuration of Spotlight settings:
- Run the Audit Log report and check for the following configuration changes of enablement or increased usage of the following settings:
- Collection schedule intervals
- Extended Events
- Spotlight Cloud
2. Revert back the changes and re-evaluate the resource consumption
- The number of monitored connections per Diagnostic Server is within the guardrails of best practices.
- The Spotlight Playback and Statistics Repository databases are on the instance sharing the same host as the Diagnostic Server. Consider separating the instance holding the database to an instance outside of this host.
- Persistent accumulation of Spotlight Playback and Statistics Repository data queuing on disk. The .bat Files can be found in installation path, by default: C:\Program Files\Quest Software\Diagnostic Server\Agent\Data\repository and \playback folders. This is an indication that your Spotlight databases cannot keep up with the Diagnostic Server transactions. Monitor the instance in Spotlight to look for areas of poor performance and bottlenecks.
- Allocate enough memory to Diagnostic Server by adjusting the configuration file – Check KB 314649 to increase the memory cap allocated to the Spotlight Diagnostic Server
- Identify what other processes are running on the same host. SQL Server and Reporting Services amongst other applications.
- Identify issues with the Spotlight Cloud feature. From Configure | Spotlight Cloud icon first confirm feature is enabled. Next, locate possible errors with uploading data to Cloud by checking the content of the Cloud.log file. In case of excessive number of errors, consider temporarily disabling the Spotlight Cloud feature.
File location: C:\Program Files\Quest Software\Diagnostic Server\Agent\log\cloud.lo
Example of error:
07 Jul 2020 16:21:49,184 ERROR [LucyServiceHttpClientCleanup(Job#5024886)] cloud - Request to https://mds-alarmingest-v4-spot-test.spotlightcloud.io/ingest/api/v4/XXX failed : 500 - Connection timed out: no further information
I hope you find the above checklist helpful.
Contact the Spotlight Support Team for additional help.