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:
Click on New Monitor link.
Enter the IP Address or Host Name of the host.
Enter the SubNetMask of the network.
Enter the port number in which sybase is running.
Enter the polling interval time in minutes.
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.
Specify the Database Name.
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.
Click Add Monitor(s). This discovers Sybase database server from the network and starts monitoring them.
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.
|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.|
|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 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 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|
|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|
|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|