To help our user community locate and post topics about their primary interest, we organize our community forum by product user communities. Click here to see a full listing of forums.
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...
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.
Chiếc lồng đèn và câu chuyện trung thu của 2 ông cháu bán vé số
Cứ mỗi dịp Trung Thu- tết đoàn viên, người ta luôn muốn dừng hết tất cả công việc hiện tại và trở về nhà xum vầy với gia đình, ăn bánh uống...
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...
I am using spotlight for SQL Server enterprise (184.108.40.20676). I have a "SQL Server connection Failure alarm that I want to acknowledge but whatever I do, the alarm stays active. I have tried acknowledging the individual alarms as well as "Status...
Is there a way to query all the monitored servers, their alarms, and their threshold setting?
Any insight would be most appreciated.
The diagnostic Server was installed with a SQL login, not a Windows one.
That SQL now login has to have its password updated.
How do I update the Diagnostic Server with the new password?
Do I have to fully re-install it?
I have installed the diagnostic server - spotlight playback on the same server as the database and the Spotlight installation. I am receiving the below error:
High Diagnostic Server - Spotlight Playback Playback error [Connection Error]: Connecting...