Sybase Database Server Monitoring


Creating a new Sybase monitor

Supported Versions: Applications Manager supports monitoring of Sybase ASE 12.5.3 and above.

Prerequisites for monitoring Sybase metrics: Click here

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

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

  1. Click on New Monitor link.
  2. Select Sybase.
  3. Enter the IP Address or Host Name of the host.
  4. Enter the SubNetMask  of the network.
  5. Enter the port number in which sybase is running.
  6. Enter the polling interval time in minutes.
  7. If you are adding a new monitor from an Admin Server, select a Managed Server.
  8. Provide the user name and password of user who has permission to access the Sybase database. The user name specified for collecting the data from Sybase should have either System Administrator role or the user should be the DB owner for master database.
  9. Specify the Database Name.
  10. Choose the Monitor Group from the combo box with which you want to associate Sybase database server Monitor (optional). You can choose multiple groups to associate your monitor.
  11. Click Add Monitor(s). This discovers Sybase 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 individual monitors listed, to view the following information.

Monitor Information

Parameters Description
Name Specifies the name of Sybase server monitor.
Health Specifies the health (Clear, Warning, Critical) of the Sybase 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.

Memory Usage

Parameters Description
Total Memory Total memory used by ASE server in kb
Used Memory Used memory available in ASE
Free Memory Free memory available in ASE
Used Memory % Percentage of memory used by ASE server

Connection Statistics

Parameters Description
Connection Time Time taken to get connected to the Sybase database ASE server
Active Remote Connections The number of active remote connections after the ASE server has restarted
Max Remote Connections The number of max remote connections available in the ASE server
Active User Connections The number of active user connections after the ASE server has restarted
Max User Connections The number of max user connections available in the ASE server

Database Details

Parameters Description
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

Current Process

Parameters Description
Process Name The name of the process currently connected to ASE server
Host/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
MemUsage The memory used by the process
Time_Blocked secs The time blocked by the process is shown (in secs).

Current Transactions

Parameters Description
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
Starttime The time at which the transaction started