The following pages are tagged with
| Page | Summary |
|---|---|
| SQL Virtual Log Files Count alarm | This alarm is raised on the SQL Server | Overview page | Disk Storage panel | Log Files component when the count of Virtual Log Files (VLFs) is excessive. |
| Tempdb Auto Growth alarm | This alarm is raised when Tempdb is configured to auto grow and a significant number of growth events are detected. |
| Tempdb Contention alarm | This alarm is raised when Tempdb is experiencing contention |
| Tempdb Version Store Generation Rate Alarm | This alarm is raised when the Tempdb Version Store growth rate is high compared to the cleanup rate. |
| Tempdb Version Store Size alarm | This alarm is raised when the Tempdb version store is too large for your environment. |
| Compiles - Percentage Recompilations alarm | The Compiles - Percentage Recompilations alarm becomes active when the average ratio between the number of recompiles and the total number of compiles exceed... |
| CPU Time Percentage Used | CPU Time Percentage Used alarm is active when the stress on the processors for the specific Azure SQL Managed Instance connection exceeds a threshold. This v... |
| Databases - Data File Group About to Grow | The Databases - Data File Group About to Grow alarm is raised when a file in the disk group is about to grow. You can use this information to ensure the time... |
| Databases - Data File Group Space Used alarm | The Databases - Data File Group Space Used Alarm is raised when a disk group (or the actual disk) is in danger of filling. |
| Databases - Dynamic Data File Group Growths Remaining alarm | The Databases - Dynamic Data File Group Growths Remaining alarm is raised when the disk space is insufficient for files to keep growing into or the maximum f... |
| Databases - Dynamic Log File Growths Remaining alarm | The Databases - Dynamic Log File Growths Remaining alarm becomes active when a non fixed size log file in any database is in danger of running out of space t... |
| Databases - Log File Space Used alarm | The Databases - Log File Space Used Alarm becomes active when a log in any database is in danger of filling. |
| Databases - Log Flush Wait Time Alarm | The Databases - Log Flush Wait Time alarm becomes active when the duration of the last log flush for a database exceeds a threshold. |
| Databases - SQL I/O Errors alarm | The Databases - SQL I/O Errors alarm is raised when I/O errors are encountered by Azure SQL Managed Instance. |
| Databases - Unavailable alarm | The Databases - Unavailable alarm becomes active when Spotlight Enterprise detects that an Azure SQL Managed Instance database is not available for reading. ... |
| Error Log - Error Count alarm | The Error Log - Error Count alarm counts the total number of entries that were filtered from the SQL Server Error Log during the last sampling period accordi... |
| Error Log - Fatal Current Process Error (severity level 20) alarm | The Error Log - Fatal Current Process Error (severity level 20) alarm becomes active when Spotlight Enterprise detects a new fatal error message that contain... |
| Error Log - Fatal Database Integrity Suspect Error (severity level 23) alarm | The Error Log - Fatal Database Integrity Suspect Error (severity level 23) alarm becomes active when Spotlight Enterprise detects a new fatal error message t... |
| Error Log - Fatal Database (dbid) Processes Error (severity level 21) alarm | The Error Log - Fatal Database (dbid) Processes Error (severity level 21) alarm becomes active when Spotlight Enterprise detects a new fatal error message th... |
| Error Log - Fatal Hardware Error (severity level 24) alarm | The Error Log - Fatal Hardware Error (severity level 24) alarm becomes active when Spotlight Enterprise detects a new fatal error message that contains the l... |
| Error Log - Fatal Hardware Error (severity level 25) alarm | The Error Log - Fatal Hardware Error (severity level 25) alarm becomes active when Spotlight Enterprise detects a new fatal error message that contains the l... |
| Error Log - Fatal Table Integrity Suspect Error (severity level 22) alarm | The Error Log - Fatal Table Integrity Suspect Error (severity level 22) alarm becomes active when Spotlight Enterprise detects a new fatal error message that... |
| Error Log - High Severity Error Log Message alarm | The Error Log - High Severity Error Log Message alarm becomes active when Spotlight Enterprise detects a new error message that contains one of the custom lo... |
| Error Log - Information Severity Error Log Message alarm | The Error Log - Information Severity Error Log Message alarm becomes active when Spotlight Enterprise detects a new error message that contains one of the cu... |
| Error Log - Low Severity Error Log Message alarm | The Error Log - Low Severity Error Log Message alarm becomes active when Spotlight Enterprise detects a new error message that contains one of the custom log... |
| Error Log - Medium Severity Error Log Message alarm | The Error Log - Medium Severity Error Log Message alarm becomes active when Spotlight Enterprise detects a new error message that contains one of the custom ... |
| Error Log - Critical Error (severity level lower than 20) alarm | The Error Log - Critical Error (severity level lower than 20) alarm becomes active when Spotlight Enterprise detects a new error message that contains one o... |
| Index Fragmentation alarm | The Index Fragmentation alarm is raised when the largest index partition on the Azure SQL Managed Instance is more than 5% fragmented. It is a good idea to d... |
| Index Fragmentation Status alarm | The Index Fragmentation Status alarm is raised when data cannot be collected. |
| I/O Stall Time alarm | The I/O Stall Time alarm becomes active when the average I/O wait time for any database file exceeds a threshold. This value is taken over a specific number ... |
| Latch - Total Wait Time Rate alarm | Latches are monitored to help identify performance bottlenecks. |
| Locks - Blocked Processes alarm | The Locks - Blocked Processes alarm is raised when a block persists for longer than the time specified in the threshold. The default is 120 seconds. |
| Locks - Deadlocks alarm | The Locks - Deadlocks alarm is raised when the number of deadlocks that have occurred since the previous data collection exceeds a threshold. |
| Memory - Free System Page Table Entries alarm | The Memory - Free System Page Table Entries (PTE) alarm is raised when this performance counter falls below a threshold. |
| Memory - Page Life Expectancy alarm | The Memory - Page Life Expectancy alarm becomes active when the page life expectancy falls below a threshold. |
| Memory - Percentage Free Virtual Memory alarm | This alarm is activated when the average free virtual memory drops below a threshold. This value is taken over a specific number of background collections. |
| Memory - Physical Memory Available alarm | The Memory - Physical Memory Available alarm is activated when the available memory drops below a threshold. |
| Missing SQL Performance Counters alarm | Spotlight Enterprise uses the Azure SQL Managed Instance virtual table sysperfinfo to retrieve data for many of its displays. In some rare cases, this table ... |
| Monitored Server - Azure SQL Managed Instance Alarm Action Failure alarm | Raised when a (specified action) failed to evaluate. |
| Monitored Server - Azure SQL Managed Instance Alarm Evaluation Failure alarm | Spotlight failed to evaluate the specified alarm from the given collection. |
| Monitored Server - Azure SQL Managed Instance Collection Execution Failure alarm | The specified collection failed to run against this server. |
| Monitored Server - Azure SQL Managed Instance Connection Failure alarm | Spotlight has failed to connect to the Azure SQL Managed Instance. |
| Monitored Server - Azure SQL Managed Instance Host Not Defined alarm | |
| Monitored Server - Azure SQL Managed Instance Planned Outage alarm | This alarm is raised during a planned outage of the connection. Spotlight will resume monitoring the service at the end of the planned outage period. |
| Monitored Server - Azure SQL Managed Instance Secondary Connection Failure alarm | The service is not responding. |
| Network - Percentage Bandwidth alarm | The average network bandwidth capacity of the specified network card is nearing the limit where it is saturating the network link. This value is taken over a... |
| Network - Azure SQL Managed Instance Packets Error Rate alarm | The Network - Azure SQL Managed Instance Packets Error Rate alarm becomes active when the rate at which Azure SQL Managed Instance is encountering network pa... |
| Paging - Disk Activity alarm | This alarm is activated when paging is low, but the average disk activity on a paging file disk is high. This value is taken over a specific number of backgr... |
| Paging - File Collision alarm | This alarm becomes active when there is more than one paging file on a single physical disk. |
| Performance Investigator alarm | |
| Poor Performance Health Alarm | The database is spending too much time waiting for bottlenecks such as locks and latches. |
| Services - Full Text Search alarm | This alarm becomes active when this SQL Server supporting service is installed but not active. |
| SQL - Long Running SQL alarm | The SQL - Long Running SQL alarm is raised when SQL has been running longer than a configured time. Because the (configured time) is unique to each environme... |
| SQL - Running out of Threads alarm | The SQL - Running out of Threads alarm is raised when the number of worker threads in use is high compared to the maximum number of worker threads configured. |
| SQL Agent - Jobs Failed alarm | The SQL Agent - Jobs Failed alarm is raised when Spotlight Enterprise detects that at least one SQL Agent job has failed in the last few minutes. |
| SQL Agent - Long Running Jobs (Percent) alarm | The SQL Agent - Long Running Jobs (Percent) alarm is raised when a SQL Agent job has been running for considerably longer than the average run time for SQL A... |
| SQL Agent - Long Running Jobs (Time) alarm | The SQL Agent - Long Running Jobs (Time) alarm is raised when a SQL Agent job has been running for a long time. |
| SQL Custom Counters alarm | The Custom Counters alarm is raised when the values of any of the custom counters you have configured exceed their thresholds or data collection fails. |
| Storage Free Space | This alarm relies on the Resources Utilization Summary, which considers the total storage space available in the environment where an Azure SQL Managed Insta... |
| Storage Percentage Used | This alarm depends on the Resources Utilization Summary, specifically the percentage of storage space available where an Azure SQL Managed Instance is deployed. |
| User - Connection Count alarm | The User - Connection Count alarm is raised when the number of users connected exceeds a threshold. |
| User - Logins Per Second alarm | The User - Logins Per Second alarm is raised when the average number of logins per second exceeds a threshold. This value is taken over a specific number of ... |
| User - Response Time alarm | The User - Response Time alarm is raised when the time taken for Spotlight to send a simple query to the monitored Azure SQL Managed instance, have it proces... |