The following pages are tagged with

PageSummary
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...