I have a specific server on my list that has a few "frozen" elements. 4 Sessions are stuck from 3 days ago. I've perused the server and found the SPID being employed for recent sessions, yet spotlight keeps these resident in the SQL Activity...
I have a team member who has installed Spotlight 12.2 client software on the laptop. When they enter the diagnostic server information they get an error message saying they are not a member of the the Diagnostic Server Admin/Diagnostic server read-only...
Does anyone have a script/process to report out of the SQL database disk usage? I need to create a Power BI report dashboard using the information from Spotlight.
Is there any view/report to see all alarm actions applied to a connection? Or a view/report to pick an alarm action and see all connections it is applied to?
We have a solution in SQL Server Always-On and we make full backup on primary node. Everything looks good but we always have spotlight Alarm "Backup - Days Since last Full Backup" on secondary. I need the acknowledgement because it's a security if...
I had to uninstall SpotLight Cloud and then installed it again.
Everything seems to be fine, diagnostic server is showing green status but i'm not receiving any data to the cloud.
the log file C:\Program Files\Quest Software\Cloud...
Hi, is there a way to filter some databases from the simple recovery alert of "Health Check" category. As far as i see you can only ignore the entire section (for the instance).
Is health check category based on alarms we can tweak? I see MSDB...
Spotlight is constantly losing connections to my servers but when I check, everything is fine. My network and server teams cannot find anything amiss - is there an issue with Spotlight?
I need to pull data from Spotlight repository like what gets displayed in 'Workload analysis page' ( sorted by Logical reads , CPU ) and store it somewhere for custom reporting .
Can someone please provide the query to get this info ?
We are using below versions of spotlight.
Diagnostic Server Scripts version: 126.96.36.19976
Recently we changed the privileges for our service account which getting used for the monitoring.
I have the spotlight server running on 188.8.131.5276 and i have looked everywhere on the website for the corresponding client download as i have rebuilt me machine but i can't find it.
My only options seem to be 12.3.1 which complains that the server...
I'm running Sportlight on SQL Server Enterprise and when I right-click on an object on the screen and select "What's this", I get a failure similar to this:
Object Not Found
The requested URL '/Temporary_Listen_Addresses...
When I upgraded Spotlight on SQL Server Enterprise to 12.1, I used the 'Federdated' configuration. I just upgraded to 12.3 and would like to combine the SpotlightStatisticsRepository database from the 'configuration' and the 'federated' server...