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 File Location alarm | This alarm is raised when Tempdb files are in the same location as other database files and I/O activity is significant and more than one drive is available. |
| Tempdb File Size alarm | This alarm is raised when files in Tempdb have different physical sizes. |
| Tempdb Growth Settings alarm | This alarm is raised when Tempdb files have nonidentical growth settings. |
| Tempdb Number of Files alarm | This alarm is raised when the number of files in the Tempdb database is less than the number of processors and the SQL Server is experiencing contention on T... |
| 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. |
| Backup - Days Since Last Full Backup alarm | The Backup - Days Since Last Full Backup Alarm becomes active when Spotlight detects that a full backup on the SQL Server database has never taken place or h... |
| Backup - Hours Since Last Differential Backup alarm | The Backup - Hours Since Last Differential Backup Alarm becomes active when Spotlight detects that a differential backup of the SQL Server database has never... |
| Backup - Minutes Since Last Log Backup alarm | The Backup - Minutes Since Last Log Backup Alarm becomes active when Spotlight detects that a log backup of the SQL Server database has never taken place or ... |
| Clusters - Failed Over alarm | The Clusters - Failed Over alarm is raised when a cluster fails over. |
| Clusters - File Share Witness Inaccessible alarm | The Clusters - File Share Witness Inaccessible alarm is raised when the cluster resource File Share Witness in a clustered service or Cluster Group applicati... |
| Clusters - Node Unavailable alarm | The Clusters - Node Unavailable Alarm alarm is raised when Spotlight detects that at least one cluster node (computer system) is not currently running as par... |
| Clusters - Non-Preferred Node alarm | The Clusters - Non-preferred Node alarm is raised when Spotlight detects that SQL Server is running on a Windows cluster, and at least one SQL Server instanc... |
| 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... |
| 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 SQL Server. |
| Databases - Unavailable alarm | The Databases - Unavailable alarm becomes active when Spotlight Enterprise detects that a SQL Server database is not available for reading. Users attempting ... |
| 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 SQL Server is more than 5% fragmented. It is a good idea to defragment large ... |
| 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. |
| LiteSpeed Backup Failed alarm | The LiteSpeed Backup Failed Alarm becomes active when the LiteSpeed backup job fails. |
| LiteSpeed Backup Warning alarm | The LiteSpeed Backup Warning Alarm becomes active when a warning is associated with the LiteSpeed backup job. |
| 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. |
| Log Shipping - Primary Backup Job alarm | The Log Shipping - Primary Backup Job alarm is raised when the backup job on the primary database is not enabled. |
| Log Shipping - Secondary Job alarm | The Log Shipping - Secondary Job alarm is raised when a secondary copy or restore job is not enabled. |
| Log Shipping - Secondary Latency alarm | The Log Shipping - Secondary Latency alarm is raised when the amount of time that elapsed between the log backup being created on the primary database and re... |
| 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. |
| Mirroring - Failedover alarm | The principal database has failed. The mirror has taken over. |
| Mirroring - State alarm | The Mirroring - State alarm is raised when the mirror database is not synchronized or is synchronizing. |
| Mirroring - Unrestored Log alarm | The Mirroring - Unrestored Log alarm is raised when the size of an unrestored mirroring log on the mirroring database exceeds a threshold. |
| Mirroring - Unsent Log alarm | The Mirroring - Unsent Log alarm is raised when the size of an unsent mirroring log exceeds a threshold. |
| Missing SQL Performance Counters alarm | Spotlight Enterprise uses the SQL Server virtual table sysperfinfo to retrieve data for many of its displays. In some rare cases, this table may not contain ... |
| Monitored Server - SQL Server Alarm Action Failure alarm | Raised when a (specified action) failed to evaluate. |
| Monitored Server - SQL Server Alarm Evaluation Failure alarm | Spotlight failed to evaluate the specified alarm from the given collection. |
| Monitored Server - SQL Server Collection Execution Failure alarm | The specified collection failed to run against this server. |
| Monitored Server - SQL Server Connection Failure alarm | Spotlight has failed to connect to the SQL Server. |
| Monitored Server - SQL Server Host Not Defined alarm | |
| Monitored Server - SQL Server 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 - SQL Server Secondary Connection Failure alarm | The service is not responding. |
| Monitored Server - SQL Server Unsupported Version alarm | This version of SQL Server is not supported by Spotlight. Some collections may fail because Spotlight has not been tested against this SQL Server version yet... |
| 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 - SQL Server Packets Error Rate alarm | The Network - SQL Server Packets Error Rate alarm becomes active when the rate at which SQL Server is encountering network packet errors exceeds a threshold. |
| 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 - DTC Service Status alarm | This alarm becomes active when this SQL Server supporting service is installed but not active. |
| Services - Full Text Search alarm | This alarm becomes active when this SQL Server supporting service is installed but not active. |
| Services - Integration Service Status alarm | This alarm becomes active when this SQL Server supporting service is installed but not active. |
| Services - Reporting Service Status 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 - Alerts alarm | The SQL Agent - Alerts alarm is raised when Spotlight Enterprise detects that at least one SQL Agent alert has occurred in the last few minutes. |
| 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 Agent - Status alarm | This alarm becomes active when this SQL Server supporting service is installed but not active. |
| 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. |
| 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 SQL Server instance, have it processed and... |