Sybase DB Servers

Introduction:

This section is common to all the editions of IT360, as per the below constraints;

Professional Edition
Enterprise Edition [Applicable to Probes only, and not applicable / relevant to the Central Server, since the configuration of the monitors happens only at the Probe level. However, you may see these discovered monitors from the Central Server]
MSP Edition [Applicable to Probes only, and not applicable / relevant to the Central Server, since the configuration of the monitors happens only at the Probe level. However, you may see these discovered monitors from the Central Server]

Supported Versions:

IT360 supports monitoring of Sybase ASE 12.5.3 and above.

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:

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, by which 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 the ASE server.

Top

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
Database Name	Name of the database instances.
Total Size	Allocated space for the database, in MB.
Used Size	Used database space, in MB.
Used Size %	Percentage of Used Size.
Creator	User, who created the database.
Health	Health of the database.

Current Process:

Parameters	Description
Process Name	The name of the process, currently connected to the 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 the process is connected to ASE.
Command	The command executed by process, connected to ASE (Note: The 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, in secs.

Current Transactions:

Parameters	Description
Type	The type of transaction.
Coordinator	The coordinator of the transaction.
State	The state of the current transaction, such as started, 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 was started.

Top