Databases Reference
In-Depth Information
Table 9.1
Available events in the SQL Server trace mechanism (continued)
Event
number
Event name
Description
75
CursorRecompile
A cursor opened on a Transact-SQL statement by ODBC or DB-
Library has been recompiled either directly or because of a schema
change.
Triggered for ANSI and non-ANSI cursors.
76
CursorImplicitConversion
A cursor on a Transact-SQL statement is converted by SQL Server
from one type to another.
Triggered for ANSI and non-ANSI cursors.
77
CursorUnprepare
A prepared cursor on a Transact-SQL statement is unprepared
(deleted) by ODBC, OLE DB, or DB-Library.
78
CursorClose
A cursor previously opened on a Transact-SQL statement by
ODBC, OLE DB, or DB-Library is closed.
79
Missing Column Statistics
Column statistics that could have been useful for the optimizer are
not available.
80
Missing Join Predicate
Query that has no join predicate is being executed. This could result
in a long-running query.
81
Server Memory Change
Microsoft SQL Server memory usage has increased or decreased by
either 1 megabyte (MB) or 5% of the maximum server memory,
whichever is greater.
92
Data File Auto Grow
Indicates that a data file was extended automatically by the server.
93
Log File Auto Grow
Indicates that a log file was extended automatically by the server.
94
Data File Auto Shrink
Indicates that a data file was shrunk automatically by the server.
95
Log File Auto Shrink
Indicates that a log file was shrunk automatically by the server.
96
Show Plan Text
Displays the query plan tree of the SQL statement from the query
optimizer.
97
Show Plan ALL
Displays the query plan with full compile-time details of the SQL
statement executed.
98
Show Plan Statistics
Displays the query plan with full runtime details of the SQL state-
ment executed.
100
RPC Output Parameter
Produces output values of the parameters for every RPC.
102
Audit Statement GDR
Occurs every time a GRANT, DENY, REVOKE for a statement
permission is issued by any user in SQL Server.
Search WWH ::
Custom Search