Sybase Database Server Monitoring


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

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 enables you to perform bulk admin configurations. Click on the individual monitors listed, to view the following information.

Monitor Information

ParametersDescription
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

ParametersDescription
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

ParametersDescription
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

ParametersDescription
Database Name Name of the database instances
Total Size Allocated space for the database in MB
Used Size Used space of database in MB
Used Size % Percentage of Used Size
Creator User who created the database
Health Health of the database


Current Process

ParametersDescription
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

ParametersDescription
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