X

Subscribe to our bi-weekly newsletter


Email:


   




 
Monitor multiple SQL Server instances
View system performance metrics
Identify performance issues and deadlocks
Use comprehensive dashboard for viewing metrics

Features

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 the SQL Server instance and their total, data, and log file size, as well as their 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 help you up with performance tuning

See next feature

SQL Server and database status monitoring

Monitor server and database to ensure their availability and pick up the issues before they evolve into anything major

See next feature

Custom metrics

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

See next feature

Comprehensive charts

View comprehensive charts that clearly depict the metric value. Turn on and off metrics and display charts in a way that suits best the individual needs. Select metric from drop down list to display it on chart

See next feature

Metric history

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

See next feature

Alerts

Be notified when a metric reaches its predefined threshold value with 24/7 notifications. Create metric baselines and set alerting to comply the calculated baseline threshold values

See next feature

Email alerting

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

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

Configurable monitoring

Enable or disable metrics and configure their details according to your preferences

See next feature

Performance baselining

Configure server baselines for desired date range and compare measured values or set alerts to use these baselines

See next feature

Server information summary

Check information and alert summary for all or for individual SQL Servers

See next feature

Custom metrics view

Create custom tabs with the most important charts and metrics

See next feature

Deadlock analysis

Track changes in real-time, without delay or propagation

See next feature

Granular device and database monitoring

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

See next feature

Data purging

Manually or automatically delete the data older than the specified time period in the repository database

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

Set desired chart size or chart metric and threshold line colors

See next feature

Alert quick focus

Review raised alerts in the same chart with a single click

See next feature

Roadmap

Query execution plan viewer

Easily access data for each problematic query through built-in query execution plan viewer. Review graphic plans and explore various attributes of the operators involved.

User security

Define different users and their privileges and increase ApexSQL Monitor security and reliability.

Reporting

Create various reports including data of your choice. Convert reports to desired file type and document any monitored period.

See our entire roadmap
ApexSQL Monitor 2014 R2 released ApexSQL Monitor 2014 R3 released ApexSQL Monitor 2015 released ApexSQL Monitor 2015 R3 Q2 ApexSQL Monitor 2015 R4 Q3
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 history
Query execution plan viewer
Query waits alerting
VM monitoring
Automatic data purge
Custom metrics
Maintenance period - Stop monitoring during certain periods by creating a black-out schedule
Wait stats
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
Custom defined alerts
Baselining
Automatic baseline calculation
Analysis
Query analysis
Trends
General
Users - Ability to define users and their privileges
Support SQL Server clusters
ApexSQL Monitor 2014 R2 released ApexSQL Monitor 2014 R3 released ApexSQL Monitor 2015 released ApexSQL Monitor 2015 R3 Q2 ApexSQL Monitor 2015 R4 Q3

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