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.
How to return multiple values using a custom counter without writing multiple queries? For example, lets say we have a custom query "select name from sys.sysdatabases" . I need all database names and not only the top DB "master"
I am getting an error when trying to use powershell module for Spotlight on SQL Server Enterprise 184.108.40.206
1. browse to "E:\Program Files (x86)\Quest Software\Spotlight Enterprise\Console\"
2. execute ds-cli.cmd
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.
Is there a query I can use to pull the disk usage out of spotlight tables?
Any recommendations for saving disk space data for long term trending? Due to space issues we only keep 7 days of data due to server space issues. I love the data Spotlights keeps, but could really use to keep the space issues for trending reports....
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...