Monitor important SQL Server instance metrics: page life expectancy, page reads and writes per second,
target and total server memory, user connections, buffer cache hit ratio, batch requests, and more.
Identify performance issues that need troubleshooting and availability of local and remote SQL Server instances
Track operating system metrics: processor utilization, network usage, paging, disk and memory related metrics,
and find out how they affect SQL Server performance. Get enough information to be able to fix performance bottlenecks.
Collect and display the data for individual devices such as a disk or network card and exclude the unneeded device from monitoring
Constantly monitor and display database status on multiple local and remote SQL Server instances, keep track of the database files size, growth rates, and plan your hardware capacities
Detect queries that use the most resources for each SQL Server instance and database. Review the statistical data for the slowest queries by CPU, execution time or I/O
Monitor metric changes continuously in real-time to get a complete picture of your server's health and behavior.
Access the charts quick and easy or change the chart size and colors for each metric and threshold displayed according to own preferences
Choose SQL Server instances to monitor. Easily enable and disable SQL Server instances. Configure and monitor the most important metrics
Identify the parameters that exceed the predefined limit. Be notified when a metric reaches its critical value. Be ready to diagnose and effectively fix the issues
View the alerts for all or for individual SQL Servers on an easy-to-read dashboard. Quickly identify the metrics that should be addressed
Avoid a large number of alerts during the regular or unpredicted maintenance of SQL Server by scheduling the maintenance periods.
Suspend monitoring of specified SQL Server instances for the defined period of time. Define a daily, weekly, and monthly recurring and the
application will take care of the rest or manually set a single maintenance period when needed
Ensure that the repository database does not exceed the maximum reasonable size and thus consume too much disk space.
Purge repository data older than the specified period manually or enable automatic data purging and specify the period
of time for which the data will be kept in the repository database. The application will check for old data regularly
and will purge data older than the specified period of time
SQL solution center
Toll free +1 866 665 5500
Copyright © 2014 ApexSQL LLC