ManageEngine® SQLDBManager Plus
SQL DB Servers Performance Metrics
ManageEngine SQLDBManager Plus supports monitoring of the following versions of Microsoft SQL versions:
2000 | 2005 | 2008 | 2012
The following are the performance metrics of a SQL server that is being monitored. Each tab provides in-depth details about SQL server metrics.
Overview: The Overview tab provides details such as Monitor Information, Availability (including 7/30 reports), Connection Statistics, Buffer and Plan Cache Hit Ratio and Top Databases based on Data File Size.
|Host: The Host Metrics tab provides details such as CPU, Memory and Disk Utilization of the Host machine on which the SQL server is running. It provides the CPU and Memory utilization for the last 6 hours, including SWAP memory. In addition, you can monitor Network Interface details, Windows Services, Processes and Event Log files that are running in the machine.|
|Memory: One of the key metrics that is being monitored in SQL Server. It provides in-depth coverage of memory usage by the SQL server which includes Total Memory, SQL Cache Memory, Lock Memory, etc, its Buffer Manager statistics - Buffer Cache Hit Ratio, Page Lookups/Min, etc, Access Method Details, Cache Details, Lock and Latch Details of the server.|
|Session: Provides you with detailed analysis of SQL server sessions with details such as Connection Statisitcs, SQL Statistics, Session Details, Session Lock Details and Session Blocked Lock Details.|
|Database: Lists the entire list of databases within the server. You can also view the Data File size (MB), percentage of log used, its status, creation date and its health and availability. You can also configure alarms for each specific database.|
|Jobs and Backup: Lists the entire list of Jobs and Backup running in the server. It also displays the Current Status, Last Run Status, last Run Date and Time, Job Time and Retries. In addition, it displays its Health. By clicking on each job, you can view the entire history of the job that was executed in the server.|
|Performance: This provides the overall performance of the SQL server by listing the Top Queries by CPU, by I/O, by CLR, Slow Running Queries, Queries that was frequently executed and blocked, Cost of missing indexes and Top Components by Memory Usage.|
|Query: You can execute specific queries within the SQL server and monitor those results through Query tab.|
|WMI Monitor: Displays the WMI performance metrics of the host machine associated with the SQL server.|
|SQL Configuration: Displays SQL Server Configurations and their values. You can also edit and change the Configuration values.|