Collection of SAP ASE data may be scheduled through either a default data collection or preconfigured statistics collections.
When an SAP ASE server is first authenticated, SCC schedules a default data collection called collection_ase_availability.
You can set up jobs in the scheduler to collect preconfigured statistics collections using the collections collection_ase_all_client_kpis, collection_ase_histmon, collection_ase_all_config_resources, or collection_ase_rat.
Listed below are the SAP ASE data collections and corresponding key performance indicators (KPIs).
The default collection of data that is set up when a server is first authenticated. The data in the default collection is gathered in 60 second intervals.
The KPIs used in the default collection include:
| Server Percent CPU Utilization | Number of Suspended Processes |
| Number of Blocked Processes | Server Availability State |
Collects the data for historical charts in the SAP ASE component, including those on the Overview, Devices, Engines, and Segments screens in the SAP Adaptive Server Enterprise monitor. Schedule this collection to see real time charting for these resources.
The KPIs used in collection_ase_all_client_kpis include:
| Active Connections in Cluster Instance | Device IO Response Time |
| Device IO Rate in Cluster Instance | Engine CPU Utilization |
| Engine CPU Utilization in Cluster Instance | Segment Space Usage |
| CPU Busy Value for Logical Cluster Workload | Server CPU Utilization |
| IO Load Value for Logical Cluster Workload | Server Device IO Rate |
| Load Score for Logical Cluster Workload | Cluster Temp DB IO Rate |
| Run Queue Length for Logical Cluster Workload | Thread User CPU Utilization |
| Device APF Reads | Thread System CPU Utilization |
| Device IO Rate | Thread Total CPU Utilization |
Collects historical statistics for an SAP ASE server. These statistics are not displayed in the SAP Adaptive Server Enterprise monitor. To view these statistics, launch the 'Statistics Chart' window from the context menu. Schedule this collection to activate alerts and view them in a statistics chart.
The KPIs used in collection_ase_histmon include:
| Workload Load Score in Cluster Instance | Number of Bytes Received in Network IO |
| Number of Bytes Received in Cluster Instance | Number of Bytes Sent in Network IO |
| Number of Bytes Sent in Cluster Instance | Number of Deadlocks |
| Number of CIPC Messages Received in Cluster Instance | Number of Locks |
| Number of CIPC Messages Sent in Cluster Instance | Number of Packets Received in Network IO |
| Number of Committed Transactions in Cluster Instance | Number of Packets Sent in Network IO |
| Number of Packets Received in Cluster Instance | Number of Page Locks |
| Number of Packets Sent in Cluster Instance | Number of Row Locks |
| Cache Hit Ratio | Number of Table Locks |
| Number of Cache Misses | Number of Transactions |
| Number of Cache Searches | Number of User Connections |
| Device Free Space | Procedure Cache Hit Ratio |
| Device Space Usage | Server Device IO Rate |
| Active Connections in Logical Cluster | sp_who Response Time |
| Number of Failover Instances in Logical Cluster | Statement Cache Hit Ratio |
| Segment Free Space | Server tempdb Free Space |
| Average Blocked Process Wait Time | Server tempdb Space Used |
| Number of Address Locks | Â |
Schedule this collection to configure alerts and be automatically notified when the utilization of any of the resources reaches a level that may require attention.
The KPI used in collection_ase_all_config_resources is Configured Resource Percentage Active.
Collects RepAgent Threads metrics for the charts on the SAP ASE component’s Replication Agent screen. Include this collection only if you are planning to monitor replication from this primary database.