Importance of Monitoring Sybase Database Servers
Databases are widely used as backends for web applications, for creating reports with business intelligence statistics, forecasting, and more. Since applications rely on database servers for their functioning, fast database access is a must for good application performance. To detect database performance issues proactively and to troubleshoot issues accurately, DBAs and IT admins need comprehensive visibility into database performance and query-level insight. With eG Enterprise
- Administrators can monitor Sybase ASE (SAP Adaptive Server Enterprise), Oracle, Microsoft SQL, MySQL, MongoDB, IBM DB2 UDB, SAP HANA and others from a central web console.
- They get visibility into all aspects of database performance - workload, configuration, memory buffers, I/O operations, queries, deadlocks, etc.
- eG Enterprise auto-correlates database performance with that of the underlying OS, virtualization, and storage tiers, automates and accelerates the discovery and diagnosis of database issues.

-
Troubleshoot Slow Sybase Performance with In-Depth Analytics
- Monitor transactions to all the databases on a server
- Identify top queries by I/O activities, CPU usage, memory usage. Highlight username, application, and terminal used for each query
- Identify long running queries
- Track missing and unused indexes and identify ways to optimize the database for best performance
- Monitor fragmentation level of database tables and indexes, and be proactively alerted to situations when online/offline tuning of the database is required
-
Analyze Database Space and Log Usage on Sybase Database Servers
- Monitor space usage by file groups; determine when the free space in a file group drops below acceptable limits
- Track usage of the tempDB; determine if it is running out of space
- Monitor the transaction logs of each of the databases. Report on databases that are using excessive transaction log space. Alert when a transaction log is reaching the maximum configured size limit.
- Be notified when reserved space, data space, and index space utilization of any database is nearing capacity
- Track activity of each of the data files. Monitor I/O stalls on the data files. Identify if the I/O activity is not balanced across all data files and if additional data files are required to balance the I/O activity
-
Monitor User Activities to Sybase Database Servers
- Track the workload to the database server. Monitor transaction rates to each of the databases.
- Report on all active application/user connections to the database server and queries being processed.
- Identify which application/user is imposing the most load on the database server. Track if there is a database connection leak that is leaving orphaned connections to the database server.
- Report on top queries to the database server by application/client, categorized by CPU, memory, and I/O time used.
-
Identify Locks and Wait Events that Slow Sybase Performance
- Track all connections to the database server by state and identify connections that are waiting for other connections.
- Report on root-blockers - i.e., queries that are blocking other queries. Provide historical insights, so administrators can trace back in time and determine if inefficient queries are causing unnecessary locks. Identify root-blockers by SPID, programs running them, and queries issued.
- Get alerted to deadlocks during query processing and identify the queries responsible for this.
- Monitor all types of waits happening on the database server. Differentiate between waits due to insufficient memory and due to slow I/O activities.
- Monitor data cache hit ratio and procedure cache ratio and be notified of specific objects that are consuming too much memory in the cache.
-
Monitor Sybase Database Server Health
Track the key parameters that can affect database server performance:
- Does the server have sufficient CPU, memory and disk resources?
- Is one of the disk drives seeing more I/O than others?
- Is there excessive disk queueing that can affect response times?
- Is the disk heavily fragmented and is defragmentation required?
- Are there any I/O errors during disk access that may indicate a faulty disk that is affecting database access?
- Get complete details of the wait events to figure out which process initiated the event.
-
What Sybase Server Monitoring with eG Enterprise Reveals
With its ability to automatically determine baselines for every metric collected in the IT infrastructure, eG Enterprise provides proactive alerts to database administrators. In-depth snapshots of the Sybase database server's usage are also provided periodically to assist with real-time and post-mortem diagnosis. Hourly, daily, and monthly trends are automatically computed, so administrators can effectively plan the utilization and capacity of their database infrastructure.
-
Monitor Sybase Database Performance from an Application Perspective
eG Enterprise application performance monitoring allows database performance to be monitored in the context of the applications using the database server.
- Without requiring any agents on the database servers, eG Enterprise APM traces all application accesses and reports on slow queries and exceptions during database processing.
- When a specific web page or URL is slow, you don't have to wonder any more as to what is causing the slowdown. eG Enterprise APM gives you the answers at your fingertips.
- This eliminates finger-pointing between application development, application operations and database admin teams.
-
How eG Enterprise Monitoring for Sybase Database Server Helps
- Generates proactive alerts based on a variety of Sybase database server statistics that are collected and analyzed in real-time.
- Beyond the capabilities of siloed Sybase server monitoring tools, eG Enterprise automatically correlates end-to-end service performance with database, server, and network performance, so you can quickly determine where the hot spots in the infrastructure are.
- Provides trending and service level reports so you can assess the current capacity of your infrastructure and plan for future expansion.
- Eliminates finger-pointing among IT administrators by ensuring that problems are easily and rapidly isolated to specific application tiers, so only specific administrators need to be involved in firefighting.
-
“• eG Enterprise has been incredibly useful and has far exceeded our expectations. Metrics relating to SQL and missing indexes have provided critical information that we had long suspected were performance issues. Now we have the information to address specific performance challenges.”
Pejman Farahi
Applications Specialist, Aird Berlis


Why eG? One Monitor to Manage All of IT.
- eG Enterprise is the only single pane-of-glass, virtualization-aware, auto-diagnostic IT infrastructure performance monitor
- Gain actionable answers to performance issues, wherever they originate, from application code to bare metal
- Understand the impact of infrastructure issues on application performance and user experience
- Unify IT performance monitoring, alerting, diagnosing, reporting, and capacity planning in a single console
- Ensure a great user experience and dramatically improve IT efficiency
- Benefit from flexible deployment options (on-premises and SaaS) and IT monitoring approaches (agentless and agent-based)
“eG Enterprise has been incredibly useful and has far exceeded our expectations. Metrics relating to SQL and missing indexes have provided critical information that we had long suspected were performance issues. Now we have the information to address specific performance challenges.”
Pejman Farahi
Applications Specialist, Aird Berlis
What is Sybase (SAP ASE)?
SAP ASE (Adaptive Server Enterprise), originally known as Sybase SQL Server, and commonly known as Sybase DB or Sybase ASE, is a relational database management system. Originally designed for Unix platforms under the name Sybase SQL Server, it was renamed Sybase ASE, then renamed again when SAP bought Sybase. It is often used for online transaction management on location and in the cloud.