What’s new – ApexSQL Monitor 2014

The new release of ApexSQL Monitor, a monitoring tool that monitors more than 30 system, SQL Server, and database performance counters in real time is released.

ApexSQL Monitor dashboard

The Overview tab is a dashboard that presents the most important performance metrics monitored by ApexSQL Monitor. Graphs are shown one below another. If alerts have been raised, it’s clearly indicated in the graph and you can see the alert list in a single click.

System performance graphs in ApexSQL Monitor 2014

Monitor system performance

ApexSQL Monitor tracks Windows metrics that indicate processor, memory, disk, paging, and network performance. These are processor time, processor queue length, network utilization, paging file usage, pages input per second, pages per second, average disk bytes per write/read, average disk queue length, average disk seconds per read/write, disk write/read bytes per second, and available memory.

The graphs are shown one under another, with a brief description of the metric they show.

System performance - Processor time graph in ApexSQL Monitor 2014

Monitor SQL Server performance

All monitored SQL Server performance metrics are shown in the SQL Server performance tab. These are: batch requests per second, longest running transaction, full scans per second, free list stalls, lazy writes per second, lock requests per seconds, deadlocks per second, user connections, total server memory, memory grants pending, buffer cache hit ratio, page life expectancy, page reads/writes per second, and page splits per second.

SQL Server performance - Batch requests per second graph in ApexSQL Monitor 2014

Monitor SQL database performance

The Database performance tab shows data file size, total database size, log file size, and log growth.

Database performance tab shows data file size, total database size, log file size, and log growth

Real-time graphs

Each metric is shown in a real-time graph that can be zoomed using the slider at the top. If the metric values are higher than the alerting thresholds, it can be clearly indicated in the graph, and you can easily go directly to the alert details.

Similar performance metrics that should be monitored and analyzed together, such as Page reads/sec and Page writes/sec, and Total server memory and Target server memory are shown in the same graph.

The graph also provides precise time and value for the point selected in the graph.

Real time graphs in ApexSQL Monitor 2014

The graph can also show three alerting thresholds (green, yellow, and red) for the metric, so you can easily determine when the metric was out of the normal value range.

Metric history

ApexSQL Monitor saves all monitored metric values in a central repository. The historic data can be viewed in the graphs, the same as the real-time data.

ApexSQL Monitor provides viewing the historic metric values for the last 24 hours, 7, and 30 days in a single click.

ApexSQL Monitor 2014 provides viewing the historic metric values

Metric filtering

All performance metrics are grouped in the following categories: performance, server, and database.

The whole metric group can be easily selected or deselected, for each monitored machine, SQL Server instance, and database.

Metric filtering in ApexSQL Monitor 2014

Alerting

ApexSQL Monitor offers three threshold levels for alerting for every metric: low, medium, and high. They can be configured in the Configure metrics dialog.

Alerting feature in ApexSQL Monitor 2014

The Period column defines the time interval after which the alert is raised again, if the metric is still out of the defined range. The default period value is 15 seconds. For non-critical metrics, set this parameter to a higher value to avoid noise caused by too frequent alert triggering.

When a metric value exceeds a predefined threshold value, an alert shown in the metric graph and alerts list.

An alert is shown in the metric graph and alerts list, when a metric value exceeds a predefined threshold value

The alerts can be cleared in the Review alerts dialog. You can dismiss the alarms for a specific metric on selected or all SQL Server instances by selecting the adequate check box, or dismiss all alarms by selecting the Resolve all alerts check box.

Resolve all alerts check box

The alert list provides easy access to the graph that shows the metric that triggered the alert.

A server that has unresolved alerts is indicated by the alert icon in the Servers list in the left pane.

Alert icon in the Servers list in the left pane

Support for SQL Server 2014

ApexSQL Monitor will fully support SQL Server 2014.

Purge data

ApexSQL Monitor stores historic data in a central database repository. Depending on the number of monitored systems, SQL Server instances, databases, and metrics, as well as alerts raised, the database repository grows. How long you will keep the data in the repository depends on your requirements.

ApexSQL Monitor provides an option to quickly delete data older than a specified number of days from the repository and thus maintain the repository size.

ApexSQL Monitor 2014 provides an option to quickly delete older data

May 16, 2014