SQL Monitor 2.3

New Features in SQL Monitor 2.3

• Top 10 expensive queries: Get an automatically generated list of the 10 queries that use the most resources on each SQL Server instance and database.
• PagerDuty integration: SQL Monitor now integrates with third–party phone and SMS alerting tool PagerDuty.
• Explicit purge options: Specify separate lengths of time to keep high, medium, and low volume data in your Data Repository.

Features

• Mobile monitoring: Use the web UI to monitor SQL Server health and performance from most mobile devices and any desktop machine.
• Intuitive overviews: Monitor performance at every level - global, machine, cluster, SQL Server, and individual database.
• SQL Monitor does not install anything on the SQL Servers being monitored: No agents, stored procedures or any other components.
• Up-to-the-minute performance data: Key metrics update every few seconds, for prompt alerts and precise performance metrics.
• Centralized alerts: Mark, clear, and comment on alerts in a centralized Alert Inbox, to work efficiently as a team.
• Maintenance windows: Schedule weekly maintenance windows, so alerts are suspended for the appropriate servers whenever you perform routine maintenance.
• Alerts via email or the UI: Get alerts by email and the Alert Inbox in the UI as soon as issues arise, so you know about them first and have the diagnostic data needed to resolve them.
• Customizable alert levels and thresholds: Tune alert levels and thresholds to your specific requirements, or get started at once using SQL Monitor's default settings.
• Comprehensive historical data: Go back in time to check your SQL Server health and performance for a specific period and pinpoint the source of problems fast.
• Embedded guides to metrics: Interpret server activity at a glance with embedded explanations of every performance measure.
• Produce reports with our SSRS pack or the UI: All your performance monitoring data is stored in a SQL Server database, so you can generate reports with our free SQL Server Reporting Services pack, or straight from the SQL Monitor UI via the Analysis tab.
• Simple, quick start-up: SQL Monitor works straight out of the box, so you can start monitoring right away.