The following pages are tagged with
| Page | Summary |
|---|---|
| SQL Virtual Log Files Count alarm | This alarm is raised on the SQL Azure | 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 File Size alarm | This alarm is raised when files in Tempdb have different physical sizes. |
| 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 SQL Azure connection exceeds a threshold. This value is calculate... |
| 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 Azure. |
| Index Fragmentation alarm | The Index Fragmentation alarm is raised when the largest index partition on the SQL Azure is more than 5% fragmented. It is a good idea to defragment large i... |
| 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 - Page Life Expectancy alarm | The Memory - Page Life Expectancy alarm becomes active when the page life expectancy falls below a threshold. |
| Missing SQL Performance Counters alarm | Spotlight Enterprise uses the SQL Azure virtual table sysperfinfo to retrieve data for many of its displays. In some rare cases, this table may not contain i... |
| Monitored Server - SQL Azure Alarm Action Failure alarm | This alarm is raised when a (specified action) failed to evaluate. |
| Monitored Server - SQL Azure Alarm Evaluation Failure alarm | Spotlight failed to evaluate the specified alarm from the given collection. |
| Monitored Server - SQL Azure Collection Execution Failure alarm | This alarm is raised when a (specified collection) failed to run against the server. |
| Monitored Server - SQL Azure Connection Failure alarm | Spotlight has failed to connect to the SQL Azure database. Check the SQL Azure connection details and SQL Azure availability. |
| Monitored Server - SQL Azure 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. |
| Network - SQL Azure Packets Error Rate alarm | The Network - SQL Azure Packets Error Rate alarm becomes active when the rate at which SQL Azure is encountering network packet errors exceeds a threshold. |
| Poor Performance Health Alarm | The database is spending too much time waiting for bottlenecks such as locks and latches. |
| 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 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 Azure instance, have it processed and ... |