Prior to downloading this Software, you must review the Software Transaction Agreement located here and confirm, by clicking the I agree check box below, that your organization accepts and is bound by the terms and conditions of the Software Transaction Agreement for this Software.
If you purchased the licenses for this Software by executing an order form with Quest or if you have an agreement with Quest that states that all purchases are governed by such agreement, then the terms and conditions of that agreement supersedes and takes precedence over the Software Transaction Agreement.
There is an alarm for large clustered indexes that require rebuilding. However, the data collection is two days old and the next data collection (which was yesterday) did not occur. The date the screen was captured was on 8/23/2019.
Is there a way to change the alert for an alarm in Spotlight to be every hour, or a certain time frame, and not on each failure?For example:The job ran 2 minutes and failed, and the alert appears: 'SQL Agent - Jobs Failed: The SQL Agent Job '###' failed 1 time between Wednesday, March 24, 2021 7:30:00 PM and Wednesday, March 24, 2021 7:32:11 PM'.Can this be shown as: 'SQL Agent...
SQL Server connection errors can include the following:"Monitored Server - SQL Server Connection Failure Cannot connect to SQL Server instance '<instance_name>' : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. : The wait operation timed out [0xFFFFFFFE]""Monitored Server - SQL Server Connection Failure ...
Receiving alarms for the two following collections: Collection 'Database Disk Space Utilization' failed: Host data is not available for the 'Database Disk Space Utilization' collection.Collection 'Tempdb File Location' failed: Host data is not available for the 'Tempdb File Location' collection.
Spotlight has stopped monitoring a Windows connection. The following error is received:Monitored Server - Windows Collection Execution Failure: Collection 'Processors' failed : WMI query 'Win32_PerfRawData_PerfOS_Processor' failed : Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).
In Azure SQL, its premium range has Read Only Replica, which you can connect with ApplicationIntent=Readonly.This can't be set this in Spotlight. In the proxy, you can only give the database name, to monitor a readonly replica. Spotlight needs to use a connection string with "ApplicationIntent=ReadOnly"