Proactive Monitoring of Sybase Database Servers

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

  SEE DEMO Free Trial
   

• 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

  SEE DEMO Free Trial
   

• 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.

  SEE DEMO Free Trial
   

• 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.

  SEE DEMO Free Trial
   

• 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.

  SEE DEMO Free Trial
   

• 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.

  SEE DEMO Free Trial
   

• 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.

  SEE DEMO Free Trial
   

• “• 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)