sybase (Sybase Monitoring)

The sybase (Sybase Monitoring) probe allows you to monitor real-time events occurring in the Sybase server. The probe provides checkpoints (or parameters) to measure the real-time database operations. The probe also allows you to create custom checkpoints as required to define monitoring profiles. When you create a custom checkpoint, the probe allows you to define an SQL command that retrieves the required information from the database. You can set up multiple monitoring profiles using these checkpoints to extract vital information about the database servers at specified intervals. You can also configure these profiles to generate alarms and QoS when the specified threshold of an event is breached and identify performance issues in servers. You can then diagnose and resolve these issues, and take preventive measures to ensure an optimal server run time.  
uimpga-ga
The sybase (Sybase Monitoring) probe allows you to monitor real-time events occurring in the Sybase server. The probe provides checkpoints (or parameters) to measure the real-time database operations. The probe also allows you to create custom checkpoints as required to define monitoring profiles. When you create a custom checkpoint, the probe allows you to define an SQL command that retrieves the required information from the database. You can set up multiple monitoring profiles using these checkpoints to extract vital information about the database servers at specified intervals. You can also configure these profiles to generate alarms and QoS when the specified threshold of an event is breached and identify performance issues in servers. You can then diagnose and resolve these issues, and take preventive measures to ensure an optimal server run time.  
The sybase probe extracts the following information about the Sybase severs:
  • Database uptime
  • Number of databases available
  • Data file size (and log file size) for each database
  • Data cache-hit ratio
  • Stored procedure cache hit ratio
  • Size of allocated memory
  • Size of memory allocated to data cache
  • Size of memory allocated to stored procedure cache
  • Number of log contention situations
  • Number of users waiting for a lock
  • Number of granted and waited page locks
  • Number of granted and waited table locks
  • Number of lock requests per database
  • Number of page locks
  • Number of table locks
  • Number of deadlocks per second
  • Number of transactions per second
  • Number of database page reads/writes per second
  • Number of disk IO
  • Number of disk reads
  • Number of disk writes
  • Number of committed transactions
  • Number of active users
  • Number of users currently logged onto the server
  • Log size
  • Device size
  • Server configuration
  • Server IO utilization
  • Server CPU utilization
  • Backup server availability
  • Active connection ratio
 
More information: