ApexSQL Monitor 2018 R2 – Product update alert

ApexSQL Monitor 2018 R2 has been released

About ApexSQL Monitor: ApexSQL Monitor is a Windows and SQL Server monitoring tool with a wide range of monitored metrics. It tracks Windows, SQL Server, AlwaysOn Availability Group and Failover Cluster instances, and database metrics on multiple local and remote machines and SQL Server instances. It monitors the most important SQL Server statistics, memory, buffer, and page metrics – batch requests per second, user connections, target and total server memory, buffer cache hit ratio, batch requests, page life expectancy, page reads and writes per second, and more. ApexSQL Monitor also tracks SQL Server wait statistics including the individual query wait statistics. Monitoring these metrics enables you to identify and troubleshoot performance problems, establish trends, set baselines, and generate built-in or custom reports.

For more information visit the ApexSQL Monitor product page

About this release:

Enhancements:

• 16 new predefined reports:
  • Top 10 queries with the highest wait time in SQL Server
  • Alerts status
  • Top 10 queries with the highest wait time in the database
  • Average Alert resolution time
  • Top 10 queries with the highest wait time for a specific wait type in SQL Server
  • Top 10 metrics with the highest number of alerts
  • Top 10 queries with the highest wait time for a specific wait type in the database
  • Top 10 SQL Server metrics with the highest number of alerts
  • Top 10 databases with the highest wait time
  • Alert severity statistics
  • Top 10 apps with the highest wait time in SQL Server
  • Indexes with high fragmentation above xx% in SQL Server
  • Top 10 apps with the highest wait time in the database
  • Indexes with high fragmentation above xx% in database
  • Top 10 wait types of total wait time in SQL Server [%]
  • Top 10 databases with the largest log growth [MB]
• The interactive, integrated report viewer
• The custom report now allows:
  • Template report creation
  • Combining predefined reports into a single report
  • Combining of report templates into a single report
• Report scheduler enables running predefined and custom reports on a schedule
• Send reports to email
• Include/exclude wait types from monitoring

Improved quality:

• 20 bugs and known issues fixed

Changes:

• Predefined reports available until now are replaced with new corresponding predefined reports
• The chart height in the instance details page is changed to 300 pixels
• The Query performance chart height is changed to 350 pixels
• The Query wait chart height is changed to 350 pixels
• The Wait stats chart height is changed to 350 pixels
• The full-size chart height is changed to 450 pixels
• The server explorer now utilizes icons with overlay

See also:
Release notes
Download