Change Auditor for SQL Server 7.2 - Event Reference Guide

Introduction Change Auditor for SQL Server Events

SQL Broker Event SQL CLR Event SQL Cursors Event SQL Database Event SQL Deprecation Event SQL Errors and Warnings Event SQL Full Text Event SQL Locks Event SQL Objects Event SQL OLEDB Event SQL Performance Event SQL Progress Report Event SQL Query Notifications Event SQL Scan Event SQL Security Audit Event SQL Server Event SQL Session Event SQL Stored Procedures Event SQL Transactions Event SQL TSQL Event SQL User-Configurable Event SQL Data Level Event

Log Events

SQL Performance Event

The SQL Performance Event facility contains event classes used to monitor Showplan events and events that are produces from the execution of SQL Data Manipulation Language (DML) operators.

Table 11. SQL Performance events
Event	Description	Severity
Auto Stats – Async Completed	Created when an automatic updating of index and column statistics has occurred asynchronously; job completed. (Disabled by default)	Medium
Auto Stats – Async Queued	Created when an automatic updating of index and column statistics has occurred asynchronously; job queued. (Disabled by default)	Medium
Auto Stats – Async Starting	Created when an automatic updating of index and column statistics has occurred asynchronously; job starting. (Disabled by default)	Medium
Auto Stats –Sync	Created when an automatic updating of index and column statistics has occurred synchronously. (Disabled by default)	Medium
Degree of Parallelism – Delete	Created when SQL Server executed a DELETE statement. (Disabled by default)	Medium
Degree of Parallelism - Insert	Created when SQL Server executed an INSERT statement. (Disabled by default)	Medium
Degree of Parallelism – Select	Created when SQL Server executed a SELECT statement. (Disabled by default)	Medium
Degree of Parallelism – Update	Created when SQL Server executed an UPDATE statement. (Disabled by default)	Medium
Performance Statistics - Cached Query Destroyed	Created when a cached query has been destroyed and the historical performance data associated with the plan is about to be destroyed. (Disabled by default)	Medium
Performance Statistics – New Batch SQL Text	Created when new batch SQL text is not present in the cache. (Disabled by default)	Medium
Performance Statistics – Queries in Ad Hoc Statement Compiled	Created when queries within an ad hoc SQL statement have been compiled. (Disabled by default)	Medium
Performance Statistics – Queries in Stored Procedure Compiled	Created when queries within a stored procedure have been compiled. (Disabled by default)	Medium
Showplan All	Created when SQL Server executes a SQL statement. (Disabled by default)	Medium
Showplan All for Query Compile	Created when SQL Server compiles a SQL statement. (Disabled by default)	Medium
Showplan Statistics Profile	Created when SQL Server executes a SQL statement. (Disabled by default)	Medium
Showplan Text	Created when SQL Server executes a SQL statement. This event class stores each event as binary data. (Disabled by default)	Medium
Showplan Text (Unencoded)	Created when SQL Server executes a SQL statement. This event class is the same as the Showplan Text event class, except the event information is formatted as a string rather than as binary data. (Disabled by default)	Medium
Showplan XML	Created when SQL Server executes a SQL statement. This event class stores each event as a well-defined XML document. (Disabled by default)	Medium
Showplan XML For Query Compile	Created when SQL Server compiles a SQL statement. (Disabled by default)	Medium
Showplan XML Statistics Profile	Created when SQL Server executes a SQL statement. (Disabled by default)	Medium
SQL: FullTextQuery	Created when SQL Server executes a full text query. (Disabled by default)	Medium

SQL Progress Report Event

The SQL Progress Report Event facility contains the Progress Report: Online Index Operation event class.

Table 12. SQL Progress Report events
Event	Description	Severity
Progress Report: Online Index Operation – Done	Created when an Online index build operation is done.	Medium
Progress Report: Online Index Operation – Inserted Row Count	Created when a row count is inserted during an Online index build operation.	Medium
Progress Report: Online Index Operation – Stage 1 Execution Begin	Created when an Online index build operation stage 1 execution begins.	Medium
Progress Report: Online Index Operation – Stage 1 Execution End	Created when an Online index build operation stage 1 execution ends.	Medium
Progress Report: Online Index Operation – Stage 2 Execution Begin	Created when an Online index build operation stage 2 execution begins.	Medium
Progress Report: Online Index Operation – Stage 2 Execution End	Created when an Online index build operation stage 2 execution ends.	Medium
Progress Report: Online Index Operation – Start	Created when an Online index build operation starts.	Medium

SQL Query Notifications Event

The SQL Query Notifications Event facility contains event classes that report information that developers and administrators can use to monitor and troubleshoot query notifications.

Table 13. SQL Query Notifications events
Event	Description	Severity
QN: Dynamics – Clock Run Finished	Created when the background thread in the Database Engine that schedules expired parameter tables for cleanup has finished. (Disabled by default)	Medium
QN: Dynamics – Clock Run Started	Created when the background thread in the Database Engine that schedules expired parameter tables for cleanup has started. (Disabled by default)	Medium
QN: Dynamics – Master Cleanup Task Finished	Created when cleanup to remove expired query notification subscription data finished. (Disabled by default)	Medium
QN: Dynamics – Master Cleanup Task Skipped	Created when the Database Engine did not perform cleanup to remove expired query notification subscription data.	Medium
QN: Dynamics – Master Cleanup Task Started	Created when cleanup to remove expired query notification subscription data has started. (Disabled by default)	Medium
QN: Parameter Table – Cleanup Task Finished	Created when cleanup for all subscriptions in a parameter table has finished.	Medium
QN: Parameter Table – Cleanup Task Started	Created when cleanup for all subscriptions in a parameter table has started.	Medium
QN: Parameter Table – LRU Counter Reset	Created when the usage count for the parameter table has been reset.	Medium
QN: Parameter Table – Number of Users Decremented	Created when the number of query notification subscriptions that reference a parameter table has decreased.	Medium
QN: Parameter Table – Number of Users Incremented	Created when the number of query notification subscriptions that reference a parameter table has increased.	Medium
QN: Parameter Table – Table Attempt Failed	Created when the database tried to drop an unused parameter table and failed.	Medium
QN: Parameter Table - Table Created	Created when a parameter table has been created in the database.	Medium
QN: Parameter Table – Table Drop Attempt	Created when the database has attempted to automatically drop an unused parameter table to free resources.	Medium
QN: Parameter Table – Table Dropped	Created when the database successfully dropped a parameter table.	Medium
QN: Parameter Table – Table Pinned	Created when the parameter table is marked for current usage by internal processing.	Medium
QN: Parameter Table – Table Unpinned	Created when the parameter table has been unpinned.	Medium
QN: Subscription Table – Broker Error Intercepted	Created when a Service Broker delivers an error in the conversation that the query notification uses.	Medium
QN: Subscription Table – Firing Failed With Broker Error	Created when a notification message fails due to a Service Broker.	Medium
QN: Subscription Table – Firing Failed Without Broker Error	Created when a notification message fails but is not due to a Service Broker error.	Medium
QN: Subscription Table – Subscription Deletion Attempt	Created when the Database Engine attempts to delete an expired subscription to free up resources.	Medium
QN: Subscription Table – Subscription Deletion Failed	Created when the attempt to delete an expired subscription has failed.	Medium
QN: Subscription Table – Subscription Destroyed	Created when the Database Engine successfully deletes an expired subscription.	Medium
QN: Subscription Table – Subscription Fired	Created when a notification subscription produces a notification message.	Medium
QN: Subscription Table – Subscription Registered	Created when the query notification subscription is successfully registered in the database.	Medium
QN: Subscription Table – Subscription Rewound	Created when the Database Engine receives a subscription request that exactly matches an existing subscription.	Medium
QN: Template – Created	Created when a query notification template has been created in the database.	Medium
QN: Template – Dropped	Created when a query notification template is removed from the database.	Medium
QN: Template – Matched	Created when a query notification template is reused.	Medium

SQL Scan Event

The SQL Scan Event facility contains scan events.

Table 14. SQL Scan events
Event	Description	Severity
Scan: Started	Created when a table or index scan is started. (Disabled by default)	Medium
Scan: Stopped	Created when a table or index scan is stopped. (Disabled by default)	Medium

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Change Auditor for SQL Server 7.2 - Event Reference Guide

SQL Performance Event

SQL Progress Report Event

SQL Query Notifications Event

SQL Scan Event