Sybase (SAP ASE) monitoring

Maximize availability, maintain optimal performance, and detect issues early with Site24x7's Sybase (SAP ASE) plugin integration. Gain insights into the health and performance of your database to prevent bottlenecks and ensure a seamless experience for end users.

Start 30-day free trial Try now, sign up in 30 seconds
Sybase Monitoring

What is Sybase?

Sybase is a relational database management system (RDBMS) known for its robustness and scalability. It offers features for transaction management, data storage, and retrieval, making it suitable for enterprise-level applications. Acquired by SAP in 2010, Sybase continues to be used in various industries, particularly finance, telecommunications, and government, for mission-critical applications and large-scale data management tasks.

Monitor the performance of Sybase with Site24x7

Ensure efficient database operations and performance by tracking memory, connections, cache, and transaction metrics.

Proactively detect potential issues and efficiently manage resources by viewing performance trends with anomaly detection, setting up threshold-based alerts for sudden spikes and dips.

Set up automated workflows to take corrective measures in Sybase when predefined threshold breaches occur.

Gain tailored insights by building custom dashboards with drag-and-drop widgets, assembling data from different parts of your infrastructure efficiently.

Get started with Site24x7's Sybase monitoring tool

Performance Metrics

The following metrics are captured by the plugin integration:

Name Description
Overview metrics
Connection Time Time taken to connect to the Sybase server (in nanoseconds).
Total Memory Total amount of memory available for the Sybase server (in MB).
Used Memory Amount of memory used by the Sybase server (in MB).
Free Memory Remaining amount of memory available for the Sybase server (in MB).
Used Memory Percentage Amount of memory used by the Sybase server (in percentage).
Max Remote Connections Number of maximum remote connections available in the Sybase server.
Active Remote Connections Number of active remote connections after the Sybase server has restarted.
Max User Connections Number of maximum user connections available in the Sybase server.
Active User Connections Number of active user connections after the Sybase server has restarted.
Max Locks Total number of locks configured to be held in the Sybase server.
Active Locks Number of locks that are in active state.
Cache Details
Max Procedure Cache Total amount of procedure cache allocated for the Sybase server.
Procedure Cache Used Amount of procedure cache that is currently in use.
Procedure Cache Used Percentage Percentage of procedure cache used with the maximum procedure cache.
Procedure Cache ReUsed Amount of procedure cache that is currently in reuse.
Configured Data Cache Amount of data cache configured during the server startup (in MB).
PhysicalReads Number of buffers read into the cache from disk.
LogicalReads Number of buffers retrieved from the cache.
PhysicalWrites Number of buffers written from the cache to disk.
Transaction Details
Coordinator The coordinator of the transaction.
State State of the current transaction: started, in process, or ended.
Connection The type of connection.
Start Time Time at which the transaction started.
Failover The failover state for the transaction.
Database Details
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).
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).
Backup Database Details
DB Name Name of the database.
Backup Status Status of the backup performed.
Suspended Processes Number of processes that are currently suspended due to the database transaction log being full.
Transaction Log Full Indicates whether the database transaction log is full.

Setup

Quick installation

If you're using Linux servers, use the Sybase plugin installer that checks the prerequisites and installs the plugin with a bash script. You don't need to manually set up the plugin if you're using the installer.

Execute the command below in the terminal to run the installer and follow the instructions displayed on-screen:
wget https://raw.githubusercontent.com/site24x7/plugins/master/sybase/installer/Site24x7SybasePluginInstaller.sh && sudo bash Site24x7SybasePluginInstaller.sh

Standard installation

If you're not using Linux servers or want to install the plugin manually, follow the steps below.

Prerequisites

Ensure you meet the following requirements before installing the plugin:

  • Download and install the Site24x7 server monitoring agent (Linux | Windows) in the network or on the specific host where the Sybase instance is running.
  • Ensure you have Python 3 or a higher version installed in your server.

  • Execute the following commands in the Sybase terminal to enable permissions for monitoring:

    sp_configure "enable monitoring", 1
    sp_configure 'statement statistics active', 1
    EXEC sp_configure 'per object statistics active', 1
    EXEC sp_configure 'wait event timing', 1
    sp_configure 'statement statistics active', 1

Installation

  • Create a folder named sybase.
  • Download the sybase.sh, sybaseDB.java, json-20140107.jar, and jconn4.jar files from our Github repository and place them in the sybase folder.
    wget https://raw.githubusercontent.com/site24x7/plugins/master/sybase/sybase.sh
    wget https://raw.githubusercontent.com/site24x7/plugins/master/sybase/sybaseDB.java
    wget https://raw.githubusercontent.com/site24x7/plugins/master/sybase/json-20140107.jar
    wget https://raw.githubusercontent.com/site24x7/plugins/master/sybase/jconn4.jar
  • Open the sybase.sh file and set the appropriate values for HOST, USERNAME, PASSWORD, and JAVA_HOME.

    For adding the JAVA_HOME value, run the command which java. Copy the output you get and paste it in the JAVA_HOME field. Make sure to add the path to the bin directory and not the path to Java.

  • Move the sybase folder to the Site24x7 Linux server monitoring plugin directory.

    /opt/site24x7/monagent/plugins/

The agent will automatically execute the plugin within five minutes and display the performance data in Site24x7.

To view performance charts and set thresholds for the various performance metrics:

  • Log in to Site24x7.
  • Navigate to Server > Plugin Integrations
  • Click the required monitor.
  • Create a folder named sybase.
  • Download the s sybase.bat, sybaseDB.java, json-20140107.jar, and jconn4.jar files from our Github repository and place them in the sybase folder.
    https://raw.githubusercontent.com/site24x7/plugins/master/sybase/sybase.bat
    https://raw.githubusercontent.com/site24x7/plugins/master/sybase/sybaseDB.java
    https://raw.githubusercontent.com/site24x7/plugins/master/sybase/json-20140107.jar
    https://raw.githubusercontent.com/site24x7/plugins/master/sybase/jconn4.jar
  • Open the sybase.bat file and set the appropriate values for HOST, USERNAME, PASSWORD, and JAVA_HOME.

    For adding the JAVA_HOME value, run the command where java. Copy the output you get and paste it in the JAVA_HOME field. Make sure to add the path to the bin directory of JDK and not the path to Java.

  • Move the sybase folder to the Site24x7 Windows server monitoring plugin directory.

    C:\Program Files (x86)\Site24x7\WinAgent\monitoring\plugins/

The agent will automatically execute the plugin within five minutes and display the performance data in Site24x7.

To view performance charts and set thresholds for the various performance metrics:

  • Log in to Site24x7.
  • Navigate to Server > Plugin Integrations
  • Click the required monitor.

Plugin Contribution

Feel free to contribute to our existing plugin and come up with suggestions or feedback on our Community.

  • Supported Platforms:

Was this document helpful?

Over 13,000 customers trust Site24x7

Brand logos of our various customers

Check out our 100+ plugin integrations, or build your own

Choose from our list of more than 100 ready-to-use plugins and monitor your full stack of applications across web servers, databases, load balancers, and more.

Apache Monitoring

Apache
HAProxy Monitoring

HAProxy
Kafka Monitoring

Kafka
ActiveMQ Monitoring

ActiveMQ
Kafka Monitoring

Kafka
Tomcat Monitoring

Apache Tomcat
Elasticsearch Monitoring

Elasticsearch
Dell iDRAC Monitoring

Dell iDRAC
NGINX Monitoring

NGINX and NGINX Plus
Memcached Monitoring

Memcached
See all plugin integrations
Start 30-day free trial Try now, sign up in 30 seconds
Request Demo
  • Request Demo
    •  Get Quote
  • Get Quote
    •