You'll receive

A bi-weekly newsletter

Exclusive discounts

Product update alerts

 
Monitor multiple SQL Server instances
View system performance metrics
Identify performance issues and deadlocks
Use comprehensive dashboard for viewing metrics
Query waits analysis
Graphical query execution plans
Baseline performance with thresholds
Visualize data with logarithmic scaling

Features

Performance base lining

Configure server performance baselines for a desired date range. Learn more

See next feature

Query execution plan viewer

Analyze problematic queries by displaying the query execution plan using an integrated query execution plan viewer. Learn more

See next feature

Reporting

Analyze SQL Server performance by generating different report types. Learn more

See next feature

SQL Server metrics monitoring

Monitor the most important SQL Server performance parameters; longest running transactions, memory grants pending, page life expectancy, page reads and writes per second, target and total server memory, buffer cache hit ratio, and more

See next feature

System metrics monitoring

Monitor the most important system performance parameters - processor utilization, disk bytes write per second, disk bytes read per second, processor queue length, available memory, and more

See next feature

Database metrics monitoring

Monitor all databases on a SQL Server instance and total, data, and log file size, as well as log growth and the number of transactions per second

See next feature

Query performance monitoring

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

See next feature

Query history and query wait type analysis

Capture wait statistics for a single or grouped query

See next feature

Wait type statistics

Review collected wait statistics and quickly identify performance issues and bottlenecks to facilitate performance tuning

See next feature

SQL Server and database status monitoring

Monitor servers and databases to ensure availability and identify issues early

See next feature

SQL Server AlwaysOn cluster support

Monitor performance for AlwaysOn availability groups

See next feature

Custom metrics

Create metrics according to custom requirements to be monitored along with standard metrics

See next feature

Metric history

Easily navigate through the charts history via the date/time picker or navigation arrows

See next feature

Alerts

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

See next feature

Email alerting

Send an email whenever an alert is raised. Send individual or summary alert report via multiple email profiles

See next feature

Alert actions

Execute SQL scripts or shell commands that will be executed when an alert is raised

See next feature

Alert period

Define the length of time for which a value must be exceeding the threshold before the alert is triggered

See next feature

User security

Define users assigned to different roles to increase monitoring security and reliability

See next feature

Configurable monitoring

Enable or disable metrics and customize details

See next feature

Server information summary

Check information and alert summary for one, some, or all SQL Servers

See next feature

Custom metrics view

Create custom tabs with preferred charts and metrics

See next feature

Logarithmic scale y-axis

Display large data ranges without hiding small but critical variations. Learn more

See next feature

Deadlock analysis

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

See next feature

Granular device and database monitoring

Monitor applicable metrics per individual disk, network card or database and exclude unneeded devices and databases

See next feature

Maintenance periods

Set recurring or one-time maintenance period intervals schedule to suspend alerting or monitoring of specified SQL Server instances

See next feature

SQL Server grouping

Group servers with similar properties to configure and/or analyze alerts and details for all servers in the group at once

See next feature

Chart configuration

Fully customize chart size, chart metrics and threshold line colors

See next feature

Alert quick focus

Review raised alerts from a chart with a single click

See next feature

Roadmap

Full SQL Server cluster support

Monitor performance of both Failover clusters and AlwaysOn availability groups

Query waits alerting

Get alerted whenever a wait exceeds a predefined wait time

Single query analytics

Get more detailed info about each single query wait

See our entire roadmap
ApexSQL Monitor 2014 R2 released ApexSQL Monitor 2014 R3 released ApexSQL Monitor 2015 released ApexSQL Monitor 2015 R3 released ApexSQL Monitor 2015 R4 Q3 ApexSQL Monitor 2015 R5 Q4 ApexSQL Monitor 2016 Q1
Monitoring
System monitoring - 15 counters
Additional counters (Disk latency, Page file usage, etc.)
Display network and disk metrics per network card or disk
Server monitoring - 17 counters
Additional counters (Disk latency, Disk space monitoring, etc.)
Database monitoring - 4 counters
Additional counters
Health status monitoring
Server availability
Database status
Hard disk status
Query monitoring
Slowest query
Worst performing query by CPU
Worst performing query by IO
Highest Execution count
Longest running queries
Query wait history
The built-in query execution plan viewer
Query waits alerting
Blocking queries
Query performance history
VM monitoring
Automatic data purge
Custom metrics
Custom system performance metrics
Maintenance period - Stop monitoring during certain periods by creating a black-out schedule
Wait stats
Add instance for monitoring using different windows credentials
Reporting
Basic reports in multiple formats
Query reports
Presenting
Dashboard
Chart layout
Configuration
Exclude\include database for monitoring
Check or modify thresholds from Alerts
Enable\disable server
Server grouping
Layout storing
Customized view
Shortcut to charts to prevent excessive scrolling
Toggle lines on and off by clicking on chart legend
One click navigation from dashboard to charts and from charts to alerts
Alerting
Email alerting
Alert actions - Execute external process, execute SQL script, send email
Alerting period threshold - Create alert only if all values in the specified period exceed the metric threshold
Maintenance period - Schedule alerting or collection to avoid certain time frames
Base lining
Baseline thresholds adjustments
Automatic baseline calculation
Custom defined alerts
Analysis
Query analysis
Single query analytics
Tips – Helpful tips to easily detect and analyze performance issues
General
Users - Ability to define users and their privileges
SQL Server AlwaysOn cluster support
Full SQL Server cluster support
SQL Server 2016 support
ApexSQL Monitor 2014 R2 released ApexSQL Monitor 2014 R3 released ApexSQL Monitor 2015 released ApexSQL Monitor 2015 R3 released ApexSQL Monitor 2015 R4 Q3 ApexSQL Monitor 2015 R5 Q4 ApexSQL Monitor 2016 Q1

Save a bundle

ApexSQL Monitor is included in ApexSQL DBA

6 ApexSQL server tools

Priority support

1 year free support and upgrades

New products added for free

Combined 65% savings

For only $2,000 more