Getting started

SQL Response monitors your SQL Server instances, and raises alerts to warn you about issues such as failed jobs, blocked processes, low memory problems and connection errors.

When a problem occurs on one of your monitored SQL Servers, the relevant alert is raised, containing details of exactly what has happened, and at what time. Each alert contains useful diagnostic data to help you identify the cause of the problem.

SQL Response also recommends maintenance actions to take on your databases, based on the data it collects about each SQL Server.

SQL Response works with any combination of SQL Server 2000, SQL Server 2005 and SQL Server 2008.

Using SQL Response

You can:

investigate alerts by looking at performance counters, captured SQL Profiler trace statements, and system processes
change the level at which an alert is raised (alerts can be raised at high, medium or low level)
adjust the thresholds for each alert type
disable alerts on one or more SQL Servers
set up configuration templates to manage alerts across a number of instances at once
filter the list of alerts by SQL Server, by groups of servers, by alert type and by timeframe
create your own set of filters and save them as a view
add comments when clearing alerts
set up email to be sent automatically whenever an alert is raised
view recommendations about databases on your monitored SQL Servers