Microsoft SQL Server Monitoring for Business Critical Application Performance
Services in most industries – healthcare, manufacturing, finance and more – rely on SQL database servers for data storage and access. Any performance degradation or unavailability of these servers can severely impact the performance of the entire service, often causing customer dissatisfaction and lost revenue.
eG Enterprise for SQL Server
eG Enterprise provides in-depth monitoring for Microsoft SQL database servers:
- Track in real-time the utilization of each of the databases hosted on the server
- Quickly identify applications that are using excessive SQL server resources
- Receive automatic early warning indicators of database performance problems
- Receive automatic early warning indicators of hardware and operating system issues that impact performance (free memory, disk utilization, CPU, and much more)
- View errors reported in Windows event logs
Automated Root-Cause Diagnosis Performance Issues in SQL
Often, application users and developers point to the SQL database server as the reason for a slowdown. In reality, the problem may be caused by other inefficient application design:
- One or more of the applications using the database server is generating queries that do not use indexes efficiently, causing increased table scans and unnecessary disk activity
- One application may hold a lock on a table, thereby causing other applications to fail
- Unusual transaction rollbacks may also indicate application design problems that need attention
The eG Microsoft SQL monitoring software highlights many of these application abnormalities to the administrators. By analyzing the locking patterns of applications, the eG Microsoft SQL monitor identifies “root” blocker processes – the ones that are causing other applications to be blocked. Ranking of applications based on their resource usage and indications of the queries they are running provides critical information that can be used by administrators to tune the usage of their Microsoft SQL servers.
eG Enterprise: SQL Monitoring Flexibilty
- Supports Microsoft SQL 7, 2000, 2005, 2008, 2012 and 2014 versions; development and express editions
- Support is also available for both named and port-based Microsoft SQL server installations
- Active/active and active/passive Microsoft SQL clusters are also supported
- Administrators have the option of deciding whether to monitor in an agent-based or agentless manner. If agent-based monitoring is used, the eG single agent technology ensures that all the applications executing on a server are monitored with a single agent, and the performance of the Microsoft SQL server can be correlated with other activities happening on the server (e.g., backup jobs executing)
eG Enterprise: SQL Monitoring Automation
With its ability to automatically determine baselines for every metric collected in the IT infrastructure, the eG Microsoft SQL monitor provides proactive alerts to administrators. In-depth snapshots of the Microsoft SQL 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 Microsoft SQL infrastructure.
What the eG Microsoft SQL Monitor Reveals
|SQL Server Performance Monitoring
- Is the Microsoft SQL database server available for servicing requests?
- What is the response time for a typical query?
- How many logins/logouts are happening on the Microsoft SQL server?
- Which applications/users are accessing the Microsoft SQL server and what is their respective resource usage?
- What queries are each of the applications currently executing?
|SQL Server Engine Monitoring
- What is the CPU utilization of the SQL database server engine?
- How much time is the SQL 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 the 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 SQL 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?
|SQL Memory Monitoring
- Is there sufficient memory available for the SQL 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?
|Operating System Monitoring
- Is there sufficient disk capacity?
- Is there excessive contention for CPU or memory resources?
- Are the disks unusually busy?
- Which processes are taking up most resources (CPU, memory, disk, etc.)?
Key benefits of the eG Enterprise for SQL Server
- Generates proactive alerts based on a variety of SQL database server statistics that are collected and analyzed in real-time
- Beyond the capabilities of siloed SQL 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 fire-fighting
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
- Only eG Enterprise automatically provides 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 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 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.”
Applications Specialist, Aird Berlis