L’utilisation des événements étendus avec Spotlight peut provoquer des problèmes de backup avec les serveurs SQL 2008R2. ... Ces problèmes provoquent des blocages de sauvegardes et la seule solution est un redémarrage du service SQL. Suite à une analyse du problème, Microsoft a conclu que Spotlight utilise rapidement événements étendus contre les serveurs SQL 2008R2, provoquant un problème.
When trying to suppress alarms for 'SQL Agent - Jobs Failed', the alarm isn't triggered when the job category is one of<br>REPL-Distribution<br>REPL-LogReader<br>REPL-Merge<br>REPL-Snapshot<br>or REPL-QueueReader<br><br>These generate alerts via the<br>“Replication - Distribution Agent Failure”,<br>“Replication - Log Reader Agent Failure”,<br>“Replication - Merge Agent Failure”,<br>“Replication - Queue Reader Agent Failure”<br>or “Replication - Snapshot Agent Failure”. NA <p>Please try the following steps: </p>
Customers reported a problem where a sql error alarm would not match or ignore the provided text, example below: ... Reason: Password did not match that for the login provided. ... [CLIENT: <local machine>]
Execute "DS-CLI.CMD"</div> <div> <div>4. ... Run the below command below:</div> </div> <div> <p>get-workloadanalysis -connectionname xxxxx_sqlserver -startdate "2025-1-30 00:00:00 AM" -enddate "2019-2-10 12:00:00 PM" -Resource "CPU"</p> </div> <div>Note:</div> <div>1.<span style="white-space: pre;"> Change the 'xxxxx' text to the name of SQL Server connection.
Customers report concerns regarding spotlight dependency on MS Visual C++ 2010 and Visual C++ 2013 (msvcr100.dll, msvcr120.dll, vccorlib120.dll ) which are End-of-Life. Enhancement request ID SES-2015. <p>SOLUTION:</p>
Customers report receiving error "Must declare the scalar variable @monitored_object", when running the reports. ... Defect ID SES-2030 ... None ... STATUS ... Issue fixed in Issue fixed in version 15..
Customers request information on how to monitor a SQL server 2022 instance, weather its officially supported and if not, in which upcoming version it will be.
Below are highlights of new features and changes: ... Monitor Amazon RDS for SQL Server Instance: ... Connect to Amazon RDS for SQL Server Instance using the new connection type ... Over 50 alarms for monitoring notification
With the deprecation of the Spotlight Cloud feature, the following functionalities will cease to be available in version 15.0 and no longer operational and supported in prior versions of Spotlight on SQL Server Enterprise:
Error 'Sending push notification failed' using the 'Send a push notification to mobile device' alarm action ... This alarm action is no longer supported due deprecation of Spotlight Cloud feature.
How to send Spotlight alarm as text or SMS alerts to phone? ... ( Ensure the email server settings are properly configured and tested.) ... For email recipient field, enter the appropriate mobile provider's email address.
As Amazon RDS for SQL Server Connection, Amazon doesn’t provide sysadmin role to any database user, user can’t give sysadmin role to any database user to provide maximum database privileges to that user.
As Amazon RDS for SQL Server Connection, Amazon doesn’t provide sysadmin role to any database user, user can’t give sysadmin role to any database user to provide maximum database privileges to that user.
Spotlight only supports TLS 1.2 or higher for reading and writing data to the Playback and SpotlightStatisticsRepository (SSR) databases. ... It does not support the older TLS 1.1 protocol. ... Some older versions of SQL Server (e.g., SQL Server 2014, 2012, or earlier) only supported TLS 1.1 in their initial release builds.
The Long Running SQL Alarm alarm allows the user to specify to not alarm for certain values, however the value in this case is the SPID of the process. ... Ideally it would be useful if the user could ignore the alarm based on certain text in a SQL query string.
Where can I find this data in the statistics repository? ... This data is not collectable as can be seen in the background Schedules: ... More information about this can be found in the help:
Can you user Windows PowerShell to create Planned Outages by command line? ... This can be done by command line and Powershell scripting.
See screenshot below with the highlighted incorrect information: ... Setting the MAX memory to 0 in SQL Server 2016 will cause SQL Server to fail. ... From Microsoft: Check link , the default maximum amount of memory is 2147483647 MB not 0, and the minimum memory amount allowable for max server memory is 128 MB.
Customers report being unable to start the spotlight service, after an upgrade and later even after a clean install, showing the following error on the event viewer: ... Cause 1: The jvm.dll file cannot find its dependencies properly.
I would like to receive email Notifications, Support Status & Security Alerts <p>Go to the following <a href="https://support.quest.com/manageprofile" target="_blank">link</a><br>Then select "My Subscriptions" tab</p>
When running the installer for Spotlight, it hangs at 0% and never completes. ... It's possible there is something within the machine environment blocking it, but this can happen even if antivirus is disabled.
Customers report that after upgrading to 14.1.x the email notification for deadlock alarms is no longer showing the DBID and instead of showing the database name, it shows <unknown> ... WORKAROUND 1:
Customers report being unable to start the service successfully after their upgrade of spotlight System requirements have changed and need to be met via upgrades.
What is new in Spotlight on SQL Server Enterprise 14.1.2? <br><strong>Resolved Issues:</strong><br><strong>Issue ID SEMB-2263</strong> ... <ul><li>Fixed the Java related vulnerabilities CVE-2023-36478 present in jetty-http.jar version 9.4.49.v20220914 and upgraded the library to the jetty-http.jar version 9.4.55.v2024062.</li><li>Fixed the Java related vulnerabilities CVE-2023-52428 present in nimbus-jose-jwt.jar version 9.31 and upgraded the library to the nimbus-jose-jwt.jar version 9.4.</li></ul>
Customers report that none of the users belonging to a new group added can see the connections. ... The first time a client is used, it requires that the diagnostic server address is specified. ... SOLUTION:<br>1- Go to the configure tab / Spotlight Icon<br>2- Select a diagnostic server / specify the hostname.<br>3- Click on Ok and the client should connect and display all the connections allowed to the user or group.
© ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center