SAP ASE Servers (Sybase ASE Servers) Monitoring Tool

Creating a new SAP ASE monitor

Supported Versions: Applications Manager's SAP ASE monitoring tool supports SAP ASE 12.5.3 and above.

Prerequisites for monitoring SAP ASE metrics:Click here

Using the REST API to add a new SAP ASE monitor:Click here

To create a SAP ASE database server monitor, follow the given steps:

Click on New Monitor link.
Select SAP ASE.
Enter the IP Address or Host Name of the host.
Enter the SubNetMask of the network.
Enter the port number in which SAP ASE is running.
Enter the polling interval time in minutes.
If you are adding a new monitor from a Central Server, select a Probe Server.
Provide the user name and password of user who has permission to access the SAP ASE database. The user name specified for collecting the data from SAP ASE should have either System Administrator role or the user should be the DB owner for master database.
Specify the Database Name.
Choose the Monitor Group from the combo box with which you want to associate SAP ASE database server Monitor (optional). You can choose multiple groups to associate your monitor.
Click Add Monitor(s). This discovers SAP ASE database server from the network and starts monitoring them.

Monitored Parameters

Availability tab gives the availability history for the past 24 hours or 30 days.
Performance tab gives the Health Status and events for the past 24 hours or 30 days.
List view tab enables you to perform bulk admin configurations.

Click on the following tabs listed to view the following information:

Monitor Information

Parameters	Description
Name	Specifies the name of SAP ASE server monitor.
Health	Specifies the health (Clear, Warning, Critical) of the SAP ASE server.
Type	Specifies the type you are monitoring.
Version	Specifies the version of the database server.
Port	Specifies the port number at which the database server is running.
Server Status	The current status of the database server itself
Started Time	The date and time that the database manager was started
Host Name	Specifies the host at which the database server is running.
Host OS	Specifies the OS of the host where the database server is running.
Last Alarm	Specifies the last alarm that was generated for the database server.
Last Polled at	Specifies the time at which the last poll was performed.
Next Poll at	Specifies the time at which the next poll is scheduled.
Availability	Shows the current status of the server - available or not available.

Overview

Parameters	Description
CONNECTION TIME
Connection Time	Time taken to get connected to the SAP ASE database server (in milliseconds).
MEMORY UTILIZATION
Total Memory	Total amount of memory available for the ASE server (in MB).
Used Memory	Amount of memory used by the ASE server (in MB).
Free Memory	Remaining amount of memory available for the ASE server (in MB).
Used Memory Percentage	Amount of memory used by the ASE server (in percentage).
REMOTE CONNECTION STATISTICS
Max Remote Connections	The number of max remote connections available in the ASE server.
Remote Connection Percentage	Percentage of the amount of active remote connections after the ASE server has restarted.
Active Remote Connections	The number of active remote connections after the ASE server has restarted.
USER CONNECTION STATISTICS
Max User Connections	The number of max user connections available in the ASE server.
Active User Connections	The number of active user connections after the ASE server has restarted.
User Connection Percentage	Percentage of the amount of active user connections after the ASE server has restarted.
LOCK STATISTICS
Max Locks	Total number of locks configured to be held in the ASE server.
Active Locks	Number of locks that are in active state.
Active Lock Percentage	Percentage of active locks with total locks configured.
DISK I/O STATISTICS
Max Disk I/O	Total number of disk I/O available in the ASE server.
Active Disk I/O	Number of disk I/O that are active and currently in use.
Active Disk I/O Percentage	Percentage of active disk I/O with the max disk I/O.
PROCEDURE CACHE USAGE
Max Procedure Cache	Total amount of procedure cache allocated for SAP ASE server.
Procedure Cache Used	Amount of procedure cache that are currently in use.
Procedure Cache Used Percentage	Percentage of procedure cache used with the max procedure cache.
Stored Procedure Request Rate	Number of stored procedure requests processed per second.
DATA CACHE USAGE
Configured Data Cache	Amount of data cache configured during the server startup (in MB).
Current Data Cache	Amount of data cache that are currently in use (in MB).
CACHE HIT RATIO
Data Cache Hit Ratio	Ratio of Logical Reads to Cache Searches performed for default cache (in percentage).
Procedure Cache Hit Ratio	Ratio of difference between procedure requests and load to requests made (in percentage).

Database

Parameters	Description
Database Details
DB Name	Name of the database instances.
Total Size	Total amount of space allocated for the database (in MB).
Used Size	Amount of space used in the database (in MB).
Free Size	Remaining amount of space available in the database (in MB).
Used Size (%)	Amount of space used in the database (in percentage).
Log Size	Amount of space allocated for logs in the database (in MB).
Log Used	Amount of space used from the allocated log space in the database (in MB).
Log Used (%)	Amount of space used from the allocated log space in the database (in percentage).
Creator	Name of the user who created the database.
Health	Health status of the database.
Database Backup Details
DB Name	Name of the database.
Backup Status	Status of the backup performed.
Backup Start Time	Date and time at which backup was started.
Backup Age	Amount of time elapsed since the last backup (in hours).
Suspended Processes	Number of processes that are currently suspended due to the database transaction log being full.
Transaction Log Full	Indicates whether the database transaction log is full. (Yes or No)
Last Checkpoint	Date and time at which checkpoint was last run for this database.
Last Transaction Log Dump	Date and time of this database’s most recently successful transaction log dump.
Transaction Details
Type	The type of the transaction
Coordinator	The coordinator of the transaction
State	The state of the current transaction like it is started or in process or ended
Connection	The type of connection
DB Name	The database name in which the transaction is executed
Process Name	The process which is executing the transaction
Transaction Name	The name of the transaction
Start Time	The time at which the transaction started

Performance

This tab displays the performace of top 10 queries in terms of various factors such as CPU Time, Memory Usage, Run Time and Wait Time.

Top 10 queries by CPU - Displays the list of top 10 queries with high CPU Time.
Top 10 queries by Memory Usage - Displays the list of top 10 queries with high Memory Usage.
Top 10 slow running queries - Displays the list of top 10 queries with high execution time.
Top 10 most waited query - Displays the list of top 10 queries with high Wait Time.

Below are the list of metrics that are displayed in this tab:

Parameters	Description
Process ID	ID of the process currently connected to ASE server.
DB Name	Name of the database currently in use.
Query	Displays the database query that is running.
CPU Time	Amount of time taken by the CPU to execute the query (in milliseconds).
Wait Time	Amount of time for which the task has waited to execute the query (in milliseconds).
Execution Time	Amount of time taken for the query to be executed (in seconds).
Memory Usage(kB)	Amount of memory utilized to execute the query (in kilobytes).
Physical Reads	Number of buffers reads that have been performed from disk while executing the query.
Logical Reads	Number of buffers reads that have been performed from cache while executing the query.

Process

Parameters	Description
Command Process Details
Process ID	ID of the process currently connected to ASE server.
Process Name	The name of the process currently connected to ASE server
Host Name/IPAddress	The Host Name / IP address of the process connected to ASE
User Name	The name in which the process is connected to ASE
DB Name	The name of the Database to which process is connected to ASE
Command	The command executed by process connected to ASE (command shown here limits to 255 chrs)
Status	The current status of the process
Physical IO	The Physical IO of the process
Memory Usage	The memory used by the process
Time Blocked	Amount of time blocked by the process (in seconds).

SAP ASE Servers (Sybase ASE Servers) Monitoring Tool

Creating a new SAP ASE monitor

Monitored Parameters

Monitor Information

Overview

Database

Performance

Process

Loved by customers all over the world

"Standout Tool With Extensive Monitoring Capabilities"

"I like Applications Manager because it helps us to detect issues present in our servers and SQL databases."

Carlos Rivero

Trusted by over 6000+ businesses globally