SQL Monitor - Summary

by Red Gate Software - Product Type: Application

Summary

SQL Monitor by Red Gate Software

URLs: red-gate-sql-monitor, red gate sql monitor, redgatesqlmonitor, red-gate, red gate, redgate

Monitors MS SQL Server, with alerts and diagnostic data. Red Gate SQL Monitor monitors the health and activity of your SQL Servers, providing you with intelligent alerts and recommendations in an intuitive interface and by email. SQL Monitor provides Web-based monitoring, monitor server performance in real time on desktop machines and mobile devices. With SQL Monitor you receive alerts via email and the UI as soon as problems arise, check global, machine, cluster, server and database health and performance at a glance. Generate reports with SSRS or the UI and get full historical data allowing you to rewind time to identify the causes of problems fast.

SQL Monitor (formerly SQL Response)

SQL Server performance monitoring and alerting

Web-based monitoring: keep an eye on server performance in real time on desktop machines and mobile devices.

Intuitive overviews: check global, machine, cluster, server and database health and performance at a glance.

Intelligent alerts: receive alerts via email and the UI as soon as problems arise.

Full historical data: rewind time to identify the causes of problems fast.

Reporting: generate reports with SSRS or the UI.

SQL Monitor is a web-based performance monitoring and alerting tool for SQL Server. Accessible from any computer or internet-enabled mobile device, SQL Monitor gives you the freedom to keep watch on your servers beyond the limits of your desktop.

Intuitive overviews present the critical information you need in a straightforward format, updated in real time. You are alerted to problems by email and the built-in Alert Inbox in the UI whenever issues arise, so you know about them first. You get a full account of the problem and crucial details to solve it, no matter how far you are from your desk.

Historical performance data is stored in a SQL Server database, so you can 'rewind' time, check what went wrong at a specific point in time, and prevent it from happening again. Use SSRS, the inbuilt Analysis tab, or export your performance monitoring data as a .csv, for comprehensive reporting on server performance.

Relentlessly tested to give you accurate information whenever and wherever you need it most, SQL Monitor is a reliable and accessible tool for SQL Server environments of every size.

SQL Monitor Key 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.

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.

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.

Embedded guides to metrics: Interpret server activity at a glance with embedded explanations of every performance measure.

Produce reports with SSRS or the UI: All your performance monitoring data is stored in a SQL Server database, so you can generate custom reports with SQL Server Reporting Services, or straight from the SQL Monitor UI via the Analysis tab.

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.

Simple, quick start-up: SQL Monitor works straight out of the box, so you can start monitoring right away.

What's New in SQL Monitor 2.2

New Features:

Maintenance window - you can now set maintenance windows to temporarily suspend alerting during set periods.

Four new alerts - you will now receive alerts when connection issues occur.

Machine offline and SQL Server instance offline alerts have been renamed Machine unreachableand SQL Server instance unreachablerespectively.

Bug Fixes:

SRP-2134: The Fragmented index alert is broken.

SRP-2927: Alert descriptions for Backup overdue, Log backup overdue and Integrity check overdue alerts need changing.

SRP-3135/ SRP-3136: The time displayed in the Occurrences tab of the Alert details page is out by 12 hours or is in the wrong format.

SRP-3018: Purge behavior does not work as expected; a backlog of data due to be purged builds up, and attempts to purge the backlog affects performance. To fix this, SQL Monitor has increased its usage of tempdb, so you may see tempdb grow by up to half the size of your Data Repository database. Once the backlog of data has been purged successfully and your SQL Server service has been restarted, tempdb size will revert back to normal.

SRP-3140: The Disk used alert description is not entirely accurate.

SRP-3090: Offline alerts: include seconds on alert timings.

SRP-2924: Allow a threshold of more than 100% for the Job duration unusual alert configuration.

SRP-2202/ SRP-1769: The availability of button in the Alert Inbox should not be determined by the visible page.

SRP-1137: Enable sorting of the SQL Process by ID to make it easier to find a particular process.

SRP-3243: On the Alert details page, trace data is retrieved only when users click a specific SQL process.

Known Issues:

SRP-495: If the Base Monitor loses its connection to the SQL Monitor Data Repository then you may see the following error, “System.Data.SqlClient.SqlException was thrown by method Query on service DataPresenterService: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding”.

SRP-1443: An internal error occurs if the database name contains a non-latin character.

SRP-2167: A user will see a “script stack space quota is exhausted” JavaScript error on Firefox when there is a lot of performance data in an alert details page. Use an alternative browser to view SQL Monitor.

SRP-2310: “Back in time” can sometime crash with an error when using IE 7. Use an alternative browser to view SQL Monitor.

SRP-2702: Long running query process ID not appearing in the SQL Processes/Trace tab.

What's New in SQL Monitor 2.1

New Features:

License deactivation is now supported

Long running query alert now supports excluding by process name

Improvements to email format

Improvement to Job duration unusual alert

Performance improvement when trace in running

Long running query: Regex on new lines are treated as distinct new regex rather than a single regex with a new line in it

New - SQL Monitor 2.0 (Formerly SQL Response)

SQL Monitor is web-based, enabling you to check on your server health and performance on the go with internet-enabled mobile devices.

Other new features include:

Intuitive overviews at global, cluster, machine, SQL Server and database levels for up-to-the minute performance data

Comprehensive historical data, so you can go back in time to identify the source of a problem fast

Reports via the UI and with SQL Server Reporting Services

Monitors MS SQL Server, with alerts and diagnostic data.

Pricing: SQL Monitor 2.3 1 Server License, SQL Monitor 2.3 5 Server License, SQL Monitor 2.3 10 Server License, SQL Monitor 2.3 with 12 Months of Support and Upgrades 1 Server License, SQL Monitor 2.3 with 12 Months of Support and Upgrades 5 Server License, SQL Monitor 2.3 with 12 Months of Support and Upgrades 10 Server License, SQL Monitor 2.3 with 24 Months of Support and Upgrades 1 Server License, SQL Monitor 2.3 with 24 Months of Support and Upgrades 5 Server License, SQL Monitor 2.3 with 24 Months of Support and Upgrades 10 Server License, SQL Monitor 2.3 with 36 Months of Support and Upgrades 1 Server License, SQL Monitor 2.3 with 36 Months of Support and Upgrades 5 Server License, SQL Monitor 2.3 with 36 Months of Support and Upgrades 10 Server License, SQL Monitor 2.3 Renewal License - 12 Months of Support and Upgrades 1 Server Renewal License, SQL Monitor 2.3 Renewal License - 12 Months of Support and Upgrades 5 Server Renewal License, SQL Monitor 2.3 Renewal License - 12 Months of Support and Upgrades 10 Server Renewal License, SQL Monitor 2.3 Renewal License - 24 Months of Support and Upgrades 1 Server Renewal License, SQL Monitor 2.3 Renewal License - 24 Months of Support and Upgrades 5 Server Renewal License, SQL Monitor 2.3 Renewal License - 24 Months of Support and Upgrades 10 Server Renewal License, SQL Monitor 2.3 Renewal License - 36 Months of Support and Upgrades 1 Server Renewal License, SQL Monitor 2.3 Renewal License - 36 Months of Support and Upgrades 5 Server Renewal License, SQL Monitor 2.3 Renewal License - 36 Months of Support and Upgrades 10 Server Renewal License

Evals & Downloads: Read the Red Gate End User License Agreement, Read the SQL Monitor Data sheet, Download the SQL Toolbelt evaluation on to your computer - Expires after 14 days

Operating System for Deployment: Windows 7, Windows Vista, Windows XP, Windows Server 2003, Windows 2000

Architecture of Product: 32Bit

Product Type: Application

Compatible Containers: Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft SQL Server 2000, Microsoft Internet Explorer 8.0, Microsoft Internet Explorer 7.0, Mozilla Firefox 3.6, Mozilla Firefox 3.5, Mozilla Firefox 3.0

Keywords: red gate sql monitor, redgate sql monitor, red gate monitor, buy red gate monitor, buy redgate monitor, red gate monitor reseller, redgate monitor reseller, red gate monitor distributor, redgate monitor distributor, price red gate monitor, price redgate monitor, order red gate monitor, order redgate monitor, purchase red gate monitor, purchase redgate monitor, upgrade red gate monitor, upgrade redgate monitor, renew red gate monitor, renew redgate monitor

Red Gate Software Red-Gate RedGate

SQL query language

Verification Verify verified Check Checking

Database DB Management

Database DB Reporting Report reports

Part numbers: PC-518574-427532 518574-427532 PC-518574-427533 518574-427533 PC-518574-427534 518574-427534 PC-518574-427535 518574-427535 PC-518574-427536 518574-427536 PC-518574-427537 518574-427537 PC-518574-427538 518574-427538 PC-518574-427539 518574-427539 PC-518574-427540 518574-427540 PC-518574-427541 518574-427541 PC-518574-427542 518574-427542 PC-518574-427543 518574-427543 PC-518574-427544 518574-427544 PC-518574-427545 518574-427545 PC-518574-427546 518574-427546 PC-518574-427547 518574-427547 PC-518574-427548 518574-427548 PC-518574-427549 518574-427549 PC-518574-427550 518574-427550 PC-518574-427551 518574-427551 PC-518574-427552 518574-427552

Mfr. Part No: P67U10M0 P67U10M12 P67U10M24 P67U10M36 P67U1M0 P67U1M12 P67U1M24 P67U1M36 P67U5M0 P67U5M12 P67U5M24 P67U5M36