ApexSQL Monitor

SQL Server, system and databasemetrics monitoring

Monitor the most important SQLServer, system and database performance parameters such as longest runningtransactions, page life expectancy, buffer cache hit ratio, processorutilization, available memory, database size, log growth and many more

Query waits and blocking queriesmonitoring and alerting

Capture query wait times forindividual and blocking queries. Review query performance history. Get alertedwhenever a wait time exceeds predefined threshold values

Monitor SQL query performance

Detect the slowest queries by CPU,execution time or I/O

Wait type statistics

Query execution plan viewer

Analyze problematic queries bydisplaying the query execution plan using an integrated query execution planviewer.

Reporting

Analyze SQL Server performance bygenerating different report types.

Performance base lining

Configure server performancebaselines for a desired date range.

SQL Server and database statusmonitoring

Monitor servers and databases toensure availability and identify issues early

Custom metrics

Create custom metrics to be monitoredalong with standard metrics. Use set of predefined Windows OS system metrics oradd custom SQL Server or database metrics

Metric history

Easily navigate through the chartshistory via the date/time slider

Alerts

Get alerted when a metric reaches itspredefined threshold value with 24/7 notifications

Individual alert management

Review, resolve or add comments onresolutions for individual alerts. Create reports for resolved alerts

Email alerting

Send an email whenever an alert israised. Send individual or summary alert reports via multiple email profiles

Alert actions

Execute SQL scripts, shell commands,or use SNMP notifications when an alert is raised

User security

Define users assigned to differentroles to increase monitoring security and reliability

Configurable monitoring

Enable or disable metrics andcustomize details

Server information summary

Check information and alert summaryfor one, some, or all SQL Servers

Custom charts view

Create custom tabs with preferredcharts and metrics

Logarithmic scale y-axis

Display large data ranges withouthiding small but critical variations.

Deadlock analysis

Set up a deadlock alert action andsave details, including a graphical presentation of the deadlock

Maintenance periods

Set recurring or one-time maintenanceperiod intervals schedule to suspend alerting or monitoring ofspecified SQLServer instances

SQL Server grouping

Group servers with similar propertiesto aggregate alerts and details for all servers in the group

Themes

Choose between dark and light coloredlayout

Web interface

The 2017 version of ApexSQL Monitorwill feature a fully Web interface for dynamic viewing and configuration.