Proactive Monitoring of Sybase Database Servers

Get detailed insights into all aspects of database performance so you can answer the key question “is your database server healthy?”. Identify the cause of performance issues quickly and rectify them at the earliest to keep MTTR low.

Start Your Trial

Trusted by leading companies

Start Trial

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.

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

Troubleshoot Slow Sybase
Performance with In-Depth Analytics

See Demo Start Trial

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.

Sybase Server Performance Monitoring	Is the Sybase database server available for servicing requests? What is the response time for a typical query? How many logins/logouts are happening on the Sybase database server? Which applications/users are accessing the Sybase database server and what is their respective resource usage? What queries are each of the applications currently executing?
Sybase Database Engine Monitoring	What is the CPU utilization of the Sybase database server engine? How much time is the Sybase server spending on processing vs. I/O? What is the typical workload on the database server? Which databases are imposing most load on the database server engine? How many processes are running, and what queries are they executing? Which user(s) are executing these queries?
Lock Activity Monitoring	What is the typical locking activity on each database? Which processes are being blocked and by whom? Which are the root-blocker processes, and what queries are they executing? Are any deadlocks happening?
Database Activity and Space Monitoring	What databases are hosted on the Sybase server? Is any of the databases reaching capacity? Which of the databases is seeing more transaction activity? How many active transactions are currently happening to each of the database server?
Sybase Server Memory Monitoring	Is there sufficient memory available for the Sybase database server? How much memory is the server consuming and how much is it willing to consume? How much memory is used for connections, how much for locks, and how much for query optimizations? What is the server's cache hit ratio? How many pages are available in the server's buffer pool? How many of these are free pages? Is Page life expectancy very low or are there many memory grants pending, indicating a memory shortage?
Operating System Monitoring	Is there sufficient disk capacity? Is there excessive contention for CPU or memory resources? Are the disks unusually busy? If so, which files are being read or being written to? Is the fragmentation level of the disks very high? Which processes are taking up most resources (CPU, memory, disk, etc.)?

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.

Try eG Enterprise for
free today

Works on cloud environments, hybrid-cloud setups and on-premises deployments
Deploy eG Enterprise using our SaaS platform or on-premises
Suitable for monitoring applications, digital workspaces and IT infrastructures

Proactive Monitoring of Sybase Database Servers

Importance of Monitoring Sybase Database Servers

Troubleshoot Slow Sybase Performance with In-Depth Analytics

Analyze Database Space and Log Usage on Sybase Database Servers