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...
I have read through some of the discussions of how to handle alarms for database backups with Availability Groups but still have not solved my issue. I do backups from the Primary replica in the Availability Group. When my AG fails over, I get alarms...
Add feature in the tool to send alert mail with high importance flag
There are cache files for each monitored instance at C:\Program Files\Quest Software\Diagnostic Server\Agent\data\caches on a default install of SOSSE. If one navigates well below the folder with the name of the instance being monitored, you find a file...
Hi. I have a question about Query Execution Statistics in Spotlight on SQL Server Enterprise, version 12.1.0. What I am wondering about is how far back does the "last 50" statistics go? That is, is it four hours, 24 hours. or forever? I don...
We are updating everything on our site to be HA and DR aware. Is Quest working on a solution to get Spotlight for SQL Enterprise AlwaysOn aware so we can use it in HA and DR?
I have a service called TunnelSetup running in my database server. Can I set an alarm for that specific service using Spotlight?
I want to spotlight's alarm to send us an email when that windows service stops running.
We have Spotlight but I'm also finding 3 Extended Events (SpotlightDeadlockDetection_<server>_3843, SpotlightResponseTimeWaitData_<server>_3843 and SpotlightWorkloadAnalysis_<server>_3843).
Can these 3 events be stopped?
Here's an example of my working wmi query:
@(gwmi -query "select * from win32_ntlogevent where eventtype=1 and timegenerated > '12/1/2017'").count
It appears that I can only use the query section, but that doesn't appear to have...
I currently have one diagnostic server monitoring one server room and 2 seat-based licenses for myself plus one other to use the client console.
I'm investigating what would be required to expand this to cover multiple computer rooms and am looking...
I am highly interested in expansion of the Powershell API to automate administration tasks. When dealing with hundreds of connections, working through the GUI is not preferable.
Does Spotlight support TLS v1.2 connections to SQL Server? Are there specifics that should be known about configuring the Diagnostic servers?
In the scenario that TLS v1 and v1.1 have been disabled on your monitored server(s).
Alarm: Monitored Server...