SQL Capture Alerting Option
Overview
The SQL Capture Alerting Option extends SQL Capture by enabling you to define customizable alerts that trigger based on SQL criteria that you define.
Major benefits include:
- Trigger alert events based on individual SQL executions that meet your criteria
- Alerts can execute custom notifications and actions
- View and navigate alerts together with SQL details and user script output in the TimeLine window
- Apply global alert definitions to groups of servers at once
Features
The SQL Capture Alerting Option lets you monitor all SQL executions within your database server, and trigger alert actions when a SQL execution meets the criteria you define.
For example, you can trigger alerts on conditions such as the following:
- SQL exceeding a specified duration (globally or for selected users, applications, etc.)
- SQL that resulted in a deadlock
- SQL that returned a specified minimum number of rows
When an alert event is triggered, the details of the event are saved to compressed flat files, along with the other data captured by SQL Capture. You can also gather and save custom information from the server using your own SQL script that gets executed when an alert triggers.
Then, you can view alert events together with performance levels, database process activity and SQL executions (when used with SQL Capture) using TimeLine’s intuitive graphical interface.
Global alerting features let you define an alert and apply it across a group of servers at once. Reports identify which alerts are in use and on which servers, to make management of large server farms easier.
Technology
The SQL Capture Alerting Option ties in to SQL Capture’s network-based sniffing technology in order to monitor all SQL executions sent to the database. Thus, like SQL Capture, it does not query the database server in order to obtain SQL execution data.
Database Support
The SQL Capture Alerting Option is available for SAP Sybase ASE, SAP Sybase IQ and Microsoft SQL Server.