Chat now with support
Chat mit Support

Change Auditor for SQL Server 7.1.1 - Event Reference Guide

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.

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.

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.

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

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

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen