SAP ASE Data Collections

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.

The user who first authenticates and monitors an SAP ASE resource owns its default collection. You can begin to schedule a default collection in one of these ways:
  • Authenticate a server after registering it. This is the default method of scheduling a default collection.
  • Create a scheduled job that is initiated when the SCC server starts.

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

collection_ase_availability

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.

Note: The default collection contains the same key performance indicators (KPIs) as the Perspective Heatchart, and therefore these KPIs need not be scheduled in additional collections.

The KPIs used in the default collection include:

Server Percent CPU Utilization Number of Suspended Processes
Number of Blocked Processes Server Availability State

collection_ase_all_client_kpis

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

collection_ase_histmon

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  

collection_ase_all_config_resources

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.

collection_ase_rat

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.

Related concepts
Role Assignment in SAP Control Center for SAP ASE
Related tasks
Configuring SAP Adaptive Server Enterprise for Monitoring
Authenticating a Login Account for a Managed Resource
Setting SAP ASE Parameters in the Configuration File
Related reference
Key Performance Indicators for SAP ASE