You'll receive

Bi-weekly updates

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
Monitor AlwaysOn availability groups and failover clusters
Analyze query waits and review query execution plans
Calculate baselines and thresholds
Monitor index performance

Features

Server information summary

Check information and alert summary for one, some, or all SQL Servers in the Group dashboard

See next feature

Instance dashboard

Quickly review basic information and health for monitored instances. Easily drill down to review metrics and alert details

See next feature

SQL Server, system and database metrics monitoring

Monitor the most important SQL Server, system and database performance parameters such as longest running transactions, page life expectancy, buffer cache hit ratio, processor utilization, available memory, database size, log growth and many more. Learn more

See next feature

SQL Server AlwaysOn and Failover Cluster support

Monitor SQL Server performance for AlwaysOn Availability Groups and Failover Cluster Instances with full graphically conveyed topology of all WSFC nodes and availability group replicas. Learn more

See next feature

Query waits and blocking queries monitoring and alerting

Capture query wait times for individual and blocking queries. Review query performance history. Get alerted whenever a wait time exceeds predefined threshold values. Learn more

See next feature

SQL query performance monitoring

Detect the slowest queries by CPU, execution time and/or I/O. Learn more

See next feature

Index monitoring

Configure database index monitoring and analyze index performance for indexes larger than the size specified by user

See next feature

Wait type statistics

Review collected wait statistics including detailed information on the top 5 wait stats categories to quickly identify performance issues and bottlenecks. 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

See next feature

Custom metrics

Create custom metrics to be monitored in addition to standard metrics. Use set of predefined Windows OS system metrics or add custom SQL Server or database metrics. Learn more

See next feature

Metric history

Easily navigate through charts history via the date/time controls

See next feature

Alerts

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

See next feature

Performance baselining

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

See next feature

Baseline threshold adjustment

Fine tune calculated baseline threshold by changing the average or standard deviation values

See next feature

Individual alert management

Review, resolve or add comments on resolutions for individual alerts. Create reports for resolved alerts. Learn more

See next feature

Email alerting

Send an email whenever an alert is raised. Send individual or summary alert reports via multiple email profiles. Learn more

See next feature

Alert actions

Execute SQL scripts, shell commands, and/or use SNMP notifications when an alert is raised. Learn more

See next feature

Alert period

Define the length of time for which a value exceeds the threshold before the alert is triggered. Learn more

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

Deadlock analysis

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

See next feature

Maintenance periods

Set recurring or one-time maintenance period intervals schedules to suspend alerting or monitoring of specified SQL Server instances. Learn more

See next feature

Logarithmic scale y-axis

Display large data ranges while including small but critical variations via logarithmic scale

See next feature

SQL Server grouping

Group servers with similar properties to aggregate alerts and details for all servers in the group. Learn more

See next feature

Panel based application dashboard

Check critical query and wait statistic information as well as alert summary for one, some, or all SQL Servers in the Group dashboard

See next feature

Themes

Choose between dark and light colored layouts

See next feature

    Get 3 free keys to ApexSQL Monitor   Learn more

Installing ApexSQL Monitor

This Knowledgebase article describes how to install ApexSQL Monitor and its components

ApexSQL Monitor installation terms, definitions, and network topography

This Knowledgebase article provides information about ApexSQL Monitor installation terms and offers a visual overview of a topography of installed components

ApexSQL Monitor setup and configuration: best practices, recommendations and options

This Knowledgebase article provides information about the best practices for ApexSQL Monitor installation and configuration

How to configure ApexSQL Monitor SSL web access (https) manually

This Knowledgebase article provides information about configuring SSL after the installation of ApexSQL Monitor to allow secure access to web server

How to migrate the repository database to a different SQL Server

This Knowledgebase article describes post migration steps after the ApexSQL Monitor central repository database has been migrated to another SQL Server instance

How to identify and troubleshoot slow-running queries in SQL Server

This Solution center article describes methods for identifying which query is running slow and why

How to detect SQL Server performance issues using baselines – Part 3

This article explains how to detect and/or troubleshoot SQL Server performance issues by using different methods for establishing and using baselines for various SQL Server performance metrics

SQL Server deadlock notifications – Part 2

The article describes a solution for detecting and alerting on SQL Server deadlocks which includes ability to provide full deadlock details in a user-friendly GUI with minimum user involvement

Troubleshooting SQL Server performance issues using wait statistics – Part 2

This article demonstrates ApexSQL Monitor’s ability in using SQL Server wait statistic to point out at the root cause of a SQL Server performance issue

Using custom SQL performance counters to monitor SQL Server

The article shows the way to create own custom SQL Server performance counters with some useful examples

Reporting directly against the ApexSQL Monitor repository with SSRS

This article describes how to create ad-hoc reports directly against the repository database with a reporting toolkit of stored procedures and SSRS reports

See more

Roadmap

Real time SQL Server activity

View active SQL Server processes

Azure SQL Database

Monitor and troubleshoot Azure SQL Database performance and availability

Issue prediction (forecasting)

Metric forecasting based on current and historical data

See our entire roadmap

The roadmap does not show maint only releases


ApexSQL Monitor 2018 R5 Released ApexSQL Monitor 2018 R7 Released ApexSQL Monitor 2018 R8 2018 Q4 ApexSQL Monitor 2019 R1 2019 Q1 ApexSQL Monitor 2019 R2 2019 Q2
Monitoring
Real time SQL Server activity
Job monitoring
Alerting
Per metric alert grouping viewer
Improved alerts filtering
Active alerts viewer
Reporting
Additional built-in reports
Selection profiles for reporting
Forecasting
Performance issues analysis
Deadlock monitoring
Metric data time slice comparison
Blocking chain
Cloud
Azure SQL Database - Managed Instance
Basic support for Azure SQL Database
Basic support for Amazon RDS for SQL Server
Full support for Azure SQL Database
Configuration
Add or remove multiple servers
Enable or disable monitoring of multiple servers
Automated baseline
User configuration - per group/server
Other
SQL Server 2019 CTP 2.0 support
Granular repository purging
Team collaboration via annonations
ApexSQL Monitor 2018 R5 Released ApexSQL Monitor 2018 R7 Released ApexSQL Monitor 2018 R8 2018 Q4 ApexSQL Monitor 2019 R1 2019 Q1 ApexSQL Monitor 2019 R2 2019 Q2

Testimonials

Our company grows quickly. We have got plans to improve monitoring our SQL infrastructure. At first I tested ApexSQL Monitor for our one important instance and I would like to use this for production. In future we need to choose monitoring software for our others instances (about 50 servers). I will recommend ApexSQL because joins simplicity and powerful capabilities. I'm surprised how much time we can save!

Tomasz Kalinowski

IT Specialist

PKO Leasing S.A.

I absolutely love ApexSQL Monitor. It is an extremely effective and reliable source for monitoring our environments. Configuration is a breeze and the interface is concise and quickly points out areas of concern. The Alerting feature makes it easy to react to system issues as well as document the process done to fix them. I have used numerous tools that are out on the market and this is hands down my favorite.

Gary Fry

Senior Database Administrator

Cox Industries, Inc.

With the help of the ApexSQL Monitor tool, we were able to pinpoint issues with our database and server within a few hours of setup. Easy, with a few steps, to setup and with well-presented information in a way that you do not need to be a DBA to have a good source of information from your MSSQL Databases and servers.

Edghar Looman

Network/Application/(Linux/Windows) server engineer

ThunderBuild B.V.

Volume pricing

per instance

1

$499

2-4

$399

5-9

$349

10-19

$299

Save a bundle

ApexSQL Monitor is included in ApexSQL DBA

All 13 ApexSQL DBA tools

Priority support

1 year free support and upgrades

New products added for free

Combined 70%+ savings