SQL Server - Host Performance Metrics
SQLDBManager Plus displays various information of the Server on which Microsoft SQL Server is running. It displays CPU, and Memory utilization which allows you to monitor and optimize the performance of memory allocated per query. Disk Utilization allows you to track the growth of your databases over a period of time and help you with capacity planning.
SQL Server - Memory Performance Metrics
SQLDBManager Plus displays Memory Usage and Buffer Manager Statistics. With the help of Buffer Manager Statistics, you can now monitor the physical I/O action taken by the SQL server to read and write pages into the disk per minute. With Memory Usage statistics you will be able to monitor the amount of SQL Cache and Lock Memory utilized by SQL server, thus helping you to identify any performance issue with your database server.
SQL Server - Session Performance Metrics
SQLDBManager Plus provides in-depth details on Connection Statistics, SQL Statistics, Active Connections, Login and Logout per Minute, SQL Compliations and Recompliations per Minute, etc. Connection Statistics. Login/Logout per Minute, etc allows you to identify the distribution load on your critical database and if it crosses certain threshold, you are intimated automatically thus allowing you to maintain optimal performance.
SQL Server - Database Performance Metrics
SQLDBManager Plus displays in-depth information on Database Name, Data File Size (in MB), Percentage of Log Used, Status of Databases, Availability and Health of Databases, etc. Through 7/30 reports, you can identify the growth patterns for various databases and use it for capacity planning according to the need.
SQL Server - Jobs & Backup Metrics
SQLDBManager Plus pulls information on Job Details such as Job Name, Current Status, Last Run Status, Health, Database Name, Start and End time, Total Time for executing the job on the Database, etc. This information about Jobs and Backup allows DBAs to identify if automated tasks are executed properly and whether backup is occuring as planned. This saves DBAs a lot of time and effort instead of monitoring them manually.
SQL Server - Query Performance Monitoring
SQLDBManager Plus provides the ability to monitor the performance of each SQL Query executed within an Microsoft Database. With this, a DBA can monitor the overall performance of the DB and pinpoint any performance bottleneck caused by a single query quickly and troubleshoot it.
SQL Server - Custom Query Monitoring
SQLDBManager Plus provides the ability to monitor any Custom SQL Query of an Microsoft Database. With this, a DBA can monitor additional performance metrics, monitor critical database tables and even expose Business Metrics to Line of Business Managers.
SQL Server - Cluster Monitoring
SQLDBManager Plus lets you monitor your SQL Server Clusters and Cluster resources. You can monitor an SQL cluster's disk utilization, storage, resource groups , network and node details. SQLDBManager Plus also provides DBAs with instant performance graphs and reports which can be grouped based on availability and health.