Lists and describes alerts you can configure for SAP ASE.
The alerts are based on the same key performance indicators (KPIs) that are collected for the performance and availability monitor displays and for the Statistics Chart.
| Alert | Description | Data Collection Name |
|---|---|---|
| Active Connections in Cluster Instance | Number of active connections to a cluster instance. | collection_ase_all_client_kpis |
| Engine CPU Utilization in Cluster Instance | Percentage CPU utilization of an instance in a shared disk cluster. | collection_ase_all_client_kpis |
| Number of Bytes Received in Cluster Instance | Number of bytes received during the current collection cycle; collected separately for each cluster instance. | collection_ase_histmon |
| Number of Bytes Sent in Cluster Instance | Number of bytes sent during the current collection cycle; collected separately for each cluster instance. | collection_ase_histmon |
| Number of CIPC Messages Received in Cluster Instance | Number of messages received during the current collection cycle; collected separately for each cluster instance. | collection_ase_histmon |
| Number of CIPC Messages Sent in Cluster Instance | Number of messages sent during the current collection cycle; collected separately for each cluster instance. | collection_ase_histmon |
| Number of Packets Received in Cluster Instance | Number of packets received during the current collection cycle; collected separately for each cluster instance. | collection_ase_histmon |
| Number of Packets Sent in Cluster Instance | Number of packets sent during the current collection cycle; collected separately for each cluster instance. | collection_ase_histmon |
| Number of Committed Transactions in Cluster Instance | Number of committed transactions in the cluster instance during the current collection cycle; collected separately for each cluster instance. | collection_ase_histmon |
| Workload Load Score in Cluster Instance | Load score in each cluster instance; collected separately for each cluster instance. | collection_ase_histmon |
| Alert | Description | Data Collection Name |
|---|---|---|
| CPU Busy Value for Logical Cluster Workload | Generates the CPU-busy chart on the Workload screen; collected separately for each cluster workload. | collection_ase_all_client_kpis |
| IO Load Value for Logical Cluster Workload | Generates the I/O-load chart on the Workload screen; collected separately for each cluster workload. | collection_ase_all_client_kpis |
| Load Score for Logical Cluster Workload | Generates the load-score chart on the Workload screen;collected separately for each cluster workload. | collection_ase_all_client_kpis |
| Run Queue Length for Logical Cluster Workload | Generates the run-queue-length chart on the Workload screen; collected separately for each cluster workload. | collection_ase_all_client_kpis |
| Alert | Description | Data Collection Name |
|---|---|---|
| Cache Hit Ratio | Hit ratio in the data cache during the current collection cycle. | collection_ase_histmon |
| Alert | Description | Data Collection Name |
|---|---|---|
| Device Free Space | Total amount of free space, in megabytes, on this device. | collection_ase_all_client_kpis |
| Device IO Rate | Rate of I/O operations per second on this device. | collection_ase_all_client_kpis |
| Device IO Response Time | Response time, in milliseconds, for I/O operations performed on this device. | collection_ase_all_client_kpis |
| Alert | Description | Data Collection Name |
|---|---|---|
| Engine CPU Utilization | Percentage of CPU cycles used by this SAP ASE engine. | collection_ase_all_client_kpis |
| Alert | Description | Data Collection Name |
|---|---|---|
| Active Connections in Logical Cluster | Number of active connections using the logical cluster at the time of collection; collected separately for each logical cluster. | collection_ase_histmon |
| Number of Failover Instances in Logical Cluster | Number of instance that are failed-over in the currently active logical cluster; collected separately for each logical cluster. | collection_ase_histmon |
| Alert | Description | Data Collection Name |
|---|---|---|
| RepAgent Thread State Change | The alert to send when a RepAgent thread changes state. | collection_ase_rat |
| Transaction Log Size | The size of a RepAgent thread's transaction log. | collection_ase_rat |
| Number of Log Operations Scanned per Second | The number of operations scanned by a RepAgent thread. | collection_ase_rat |
| Number of Log Operations Processed per Second | The number of operations processed by a RepAgent thread. | collection_ase_rat |
| Alert | Description | Data Collection Name |
|---|---|---|
| ASE Configured Resource Utilization | Percentage utilization of an ASE Configured Resource item. | collection_ase_all_config_resources |
| Alert | Description | Data Collection Name |
|---|---|---|
| Segment Free Space | Amount of free space in the segment; collected separately for each segment. | collection_ase_histmon |
| Alert | Description | Data Collection Name |
|---|---|---|
| Average Blocked Process Wait Time | Average time, in milliseconds, that the current blocked processes have waited. | collection_ase_histmon |
| Long Running Transaction Execution Time | Execution time of longest running transaction | collection_ase_histmon |
| Number of Address Locks | Number of address-level locks server-wide. | collection_ase_histmon |
| 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. | collection_ase_availability |
| Number of Bytes Received in Network IO | Number of bytes received during the current collection cycle. | collection_ase_histmon |
| Number of Bytes Sent in Network IO | Number of bytes sent during the current collection cycle. | collection_ase_histmon |
| Number of Critical Flags Last Collection | Number of critical flags received during the collection cycle. | collection_ase_histmon |
| Number of Deadlocks | Number of deadlocks on the server since the most recent execution of the collection. | collection_ase_histmon |
| Number of Error Flags | Number of error flags received during the collection cycle. | collection_ase_histmon |
| Number of Information Flags | Number of information flags received during the collection cycle. | collection_ase_histmon |
| Number of Locks | Total number of active locks of all types on the server. | collection_ase_histmon |
| Number of Packets received in Network IO | Number of packets received during the current collection cycle. | collection_ase_histmon |
| Number of Packets sent in Network IO | Number of packets sent during the current collection cycle. | collection_ase_histmon |
| Number of Packets sent in Network IO | Number of packets sent during the current collection cycle. | collection_ase_histmon |
| Number of Page Locks | Number of page-level locks server-wide. | collection_ase_histmon |
| Number of Row Locks | Number of row-level locks server-wide. | collection_ase_histmon |
| Number of Suspended Processes | Number of processes that are currently suspended. The heat chart uses this metric to display server status. | collection_ase_availability |
| Number of Table Locks | Number of table-level locks server-wide. | collection_ase_histmon |
| Number of Transactions | Total number of transactions during the current collection cycle. | collection_ase_histmon |
| Number of User Connections | Current number of user connections on the server. | collection_ase_histmon |
| Number of Warning Flags | Number of warning flags received during the collection cycle. | collection_ase_histmon |
| Procedure Cache Hit Ratio | Hit ratio in the procedure cache. | collection_ase_histmon |
| Resource State | Status of the SAP ASE server. Values of most interest are stopped and running. | collection_ase_availability |
| Server CPU Utilization | Average CPU utilization percentage across all active engines on the server. | collection_ase_availability, collection_ase_all_client_ kpis |
| Server Device IO Rate | Total number of I/O operations performed by all devices on the server during the current collection cycle. | collection_ase_availability, collection_ase_all_client_ kpis |
| Server tempdb Free Space | Amount of free space in the tempdb database, in megabytes. | collection_ase_histmon |
| Server tempdb Space Used | Amount of space used by the tempdb database, in megabytes. | collection_ase_histmon |
| 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 performance statistics. | collection_ase_histmon |
| Statement Cache Hit Ratio | Hit ratio in the statement cache during the current collection cycle. | collection_ase_histmon |
| Alert | Description | Data Collection Name |
|---|---|---|
| Thread CPU Utilization | Total CPU utilization by a thread, including user and system CPU utilization. | collection_ase_all_client_ kpis |