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
- Supported Platforms:
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.
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", 1sp_configure 'statement statistics active', 1EXEC sp_configure 'per object statistics active', 1EXEC sp_configure 'wait event timing', 1sp_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.shwget https://raw.githubusercontent.com/site24x7/plugins/master/sybase/sybaseDB.javawget https://raw.githubusercontent.com/site24x7/plugins/master/sybase/json-20140107.jarwget 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.bathttps://raw.githubusercontent.com/site24x7/plugins/master/sybase/sybaseDB.javahttps://raw.githubusercontent.com/site24x7/plugins/master/sybase/json-20140107.jarhttps://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:
Over 13,000 customers trust Site24x7
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.
