Lists and describes alert templates you can use to create alert instances for Adaptive Server.
The alert templates are based on the same key performance indicators (KPIs) that are collected for the performance and availability monitor displays and for the Statistics Chart.
| Adaptive Server Objects | Alert Template | Description |
|---|---|---|
| Cluster Instances | Active Connections in Cluster Instance | Number of active connections to a cluster instance. |
| Engine CPU Utilization in Cluster Instance | Percentage CPU utilization of a instance in a shared disk cluster. | |
| Number of Bytes Received in Cluster Instance | Number of bytes received during the current collection cycle. This KPI is collected separately for each cluster instance. | |
| Number of Bytes Sent in Cluster Instance | Number of bytes sent during the current collection cycle. This KPI is collected separately for each cluster instance. | |
| Number of CIPC Messages Received in Cluster Instance | Number of messages received during the current collection cycle. This KPI is collected separately for each cluster instance. | |
| Number of CIPC Messages Sent in Cluster Instance | Number of messages sent during the current collection cycle. This KPI is collected separately for each cluster instance. | |
| Number of Packets Received in Cluster Instance | Number of packets received during the current collection cycle. This KPI is collected separately for each cluster instance. | |
| Number of Packets Sent in Cluster Instance | Number of packets sent during the current collection cycle. This KPI is collected separately for each cluster instance. | |
| Number of Committed Transactions in Cluster Instance | Number of committed transactions in the cluster instance during the current collection cycle. This KPI is collected separately for each cluster instance. | |
| Workload Load Score in Cluster Instance | Load score in each cluster instance. This KPI is collected separately for each cluster instance. | |
| Cluster Workload | CPU Busy Value for Logical Cluster Workload | This KPI is collected separately for each cluster workload and is used to generate the CPU busy chart on the Workload screen. |
| IO Load Value for Logical Cluster Workload | This KPI is collected separately for each cluster workload and is used to generate the IO load chart on the Workload screen. | |
| Load Score for Logical Cluster Workload | This KPI is collected separately for each cluster workload and is used to generate the load score chart on the Workload screen. | |
| Run Queue Length for Logical Cluster Workload | This KPI is collected separately for each cluster workload and is used to generate the run queue length chart on the Workload screen. | |
| Data Caches | Cache Hit Ratio | Hit ratio in the data cache during the current collection cycle. |
| Devices | Device IO Rate | Rate of I/O operations per second on this device. |
| Device IO Response Time | Response time, in milliseconds, for I/O operations performed on this device. | |
| Device Free Space | Total amount of free space, in megabytes, on this device. | |
| Engines | Engine CPU Utilization | Percentage of CPU cycles used by this Adaptive Server engine. |
| Logical Clusters | Active Connections in Logical Cluster | Number of active connections using the Logical Cluster at the time of collection. This KPI is collected separately for each Logical Cluster. |
| Number of Failover Instances in Logical Cluster | Number of instance that are failed-over in the currently active Logical Cluster. This KPI is collected separately for each logical cluster. | |
| Replication Agent | RepAgent Thread State Change | The alert to send when an Adaptive Server RepAgent Thread changes state. |
| Transaction Log Size | The size of an Adaptive Server RepAgent Thread's transaction log. | |
| Number of Log Operations Scanned per Second | The number of operations scanned by an Adaptive Server RepAgent thread. | |
| Number of Log Operations Processed per Second | The number of operations processed by an Adaptive Server RepAgent thread. | |
| Segments | Segment Free Space | Amount of free space in the segment. This KPI is collected separately for each segment. |
| Server | Average Blocked Process Wait Time | Average time, in milliseconds, that the current blocked processes have waited. |
| Number of Address Locks | Number of address-level locks server-wide. | |
| Number of Blocked Processes | Number of currently blocked processes that have been blocked for more than 5 seconds. The Heat Chart uses this metric to display server status. | |
| Number of Bytes Received in Network IO | Number of bytes received during the current collection cycle. | |
| Number of Bytes Sent in Network IO | Number of bytes sent during the current collection cycle. | |
| Number of Deadlocks | Number of deadlocks on the server since the most recent execution of the collection. | |
| Number of Locks | Total number of active locks of all types on the server. | |
| Number of Packets received in Network IO | Number of packets received during the current collection cycle. | |
| Number of Packets sent in Network IO | Number of packets sent during the current collection cycle. | |
| Number of Page Locks | Number of page-level locks server-wide. | |
| Number of Row Locks | Number of row-level locks server-wide. | |
| Number of Suspended Processes | Number of processes that are currently suspended. The Heat Chart uses this metric to display server status. | |
| Number of Table Locks | Number of table-level locks server-wide. | |
| Number of Transactions | Total number of transactions during the current collection cycle. | |
| Number of User Connections | Current number of user connections on the server. | |
| Procedure Cache Hit Ratio | Hit ratio in the procedure cache. | |
| Resource State | Status of the Adaptive Server. Values of most interest are STOPPED and RUNNING. | |
| Server CPU Utilization | Average CPU utilization percentage across all active Adaptive Server engines on the server. | |
| Server Device IO Rate | Total number of I/O operations performed by all devices on the server during the current collection cycle. | |
| Server tempdb Free Space | Amount of free space in the tempdb database, in megabytes. | |
| Server tempdb Space Used | Amount of space used by the tempdb database, in megabytes. | |
| sp_who Response Time | Time in milliseconds the sp_who stored procedure takes to return a response. sp_who is called each time collection_ase_histmon is executed to collect Adaptive Server performance statistics. | |
| Statement Cache Hit Ratio | Hit ratio in the statement cache during the current collection cycle. |