笔记290 SQL Trace里面的事件号和对应的事件

笔记290 SQL Trace里面的事件号和对应的事件

1 --SQL Trace里面的事件号和对应的事件

 


Event number
Event name

Description
0-9 Reserved  
10 RPC:Completed Occurs when a remote procedure call (RPC) has completed.
11 RPC:Starting Occurs when an RPC has started.
12 SQL:BatchCompleted Occurs when a Transact-SQL batch has completed.
13 SQL:BatchStarting Occurs when a Transact-SQL batch has started.
14 Login Occurs when a user successfully logs in to SQL Server.
15 Logout Occurs when a user logs out of SQL Server.
16 Attention Occurs when attention events, such as client-interrupt requests or broken client connections, happen.
17 ExistingConnection Detects all activity by users connected to SQL Server before the trace started.
18 ServiceControl Occurs when the SQL Server service state is modified.
19 DTCTransaction Tracks Microsoft Distributed Transaction Coordinator (MS DTC) coordinated transactions between two or more databases.
20 Login Failed Indicates that a login attempt to SQL Server from a client failed.
21 EventLog Indicates that events have been logged in the Microsoft Windows NT® application log.
22 ErrorLog Indicates that error events have been logged in the SQL Server error log.
23 Lock:Released Indicates that a lock on a resource, such as a page, has been released.
24 Lock:Acquired Indicates acquisition of a lock on a resource, such as a data page.
25 Lock:Deadlock Indicates that two concurrent transactions have deadlocked each other by trying to obtain incompatible locks on resources the other transaction owns.
26 Lock:Cancel Indicates that the acquisition of a lock on a resource has been canceled (for example, due to a deadlock).
27 Lock:Timeout Indicates that a request for a lock on a resource, such as a page, has timed out due to another transaction holding a blocking lock on the required resource. Time-out is determined by the @@LOCK_TIMEOUT function, and can be set with the SET LOCK_TIMEOUT statement.
28 DOP Event Occurs before a SELECT, INSERT, or UPDATE statement is executed.
29-31 Reserved Use Event 28 instead.
32 Reserved  
33 Exception Indicates that an exception has occurred in SQL Server.
34 SP:CacheMiss Indicates when a stored procedure is not found in the procedure cache.
35 SP:CacheInsert Indicates when an item is inserted into the procedure cache.
36 SP:CacheRemove Indicates when an item is removed from the procedure cache.
37 SP:Recompile Indicates that a stored procedure was recompiled.
38 SP:CacheHit Indicates when a stored procedure is found in the procedure cache.
39 SP:ExecContextHit Indicates when the execution version of a stored procedure has been found in the procedure cache.
40 SQL:StmtStarting Occurs when the Transact-SQL statement has started.
41 SQL:StmtCompleted Occurs when the Transact-SQL statement has completed.
42 SP:Starting Indicates when the stored procedure has started.
43 SP:Completed Indicates when the stored procedure has completed.
44 Reserved Use Event 40 instead.
45 Reserved Use Event 41 instead.
46 Object:Created Indicates that an object has been created, such as for CREATE INDEX, CREATE TABLE, and CREATE DATABASE statements.
47 Object:Deleted Indicates that an object has been deleted, such as in DROP INDEX and DROP TABLE statements.
48 Reserved  
49 Reserved  
50 SQL Transaction Tracks Transact-SQL BEGIN, COMMIT, SAVE, and ROLLBACK TRANSACTION statements.
51 Scan:Started Indicates when a table or index scan has started.
52 Scan:Stopped Indicates when a table or index scan has stopped.
53 CursorOpen Indicates when a cursor is opened on a Transact-SQL statement by ODBC, OLE DB, or DB-Library.
54 Transaction Log Tracks when transactions are written to the transaction log.
55 Hash Warning Indicates that a hashing operation (for example, hash join, hash aggregate, hash union, and hash distinct) that is not processing on a buffer partition has reverted to an alternate plan. This can occur because of recursion depth, data skew, trace flags, or bit counting.
56-57 Reserved  
58 Auto Update Stats Indicates an automatic updating of index statistics has occurred.
59 Lock:Deadlock Chain Produced for each of the events leading up to the deadlock.
60 Lock:Escalation Indicates that a finer-grained lock has been converted to a coarser-grained lock (for example, a row lock escalated or converted to a page lock).
61 OLE DB Errors Indicates that an OLE DB error has occurred.
62-66 Reserved  
67 Execution Warnings Indicates any warnings that occurred during the execution of a SQL Server statement or stored procedure.
68 Execution Plan Displays the plan tree of the Transact-SQL statement executed.
69 Sort Warnings Indicates sort operations that do not fit into memory. Does not include sort operations involving the creating of indexes; only sort operations within a query (such as an ORDER BY clause used in a SELECT statement).
70 CursorPrepare Indicates when a cursor on a Transact-SQL statement is prepared for use by ODBC, OLE DB, or DB-Library.
71 Prepare SQL ODBC, OLE DB, or DB-Library has prepared a Transact-SQL statement or statements for use.
72 Exec Prepared SQL ODBC, OLE DB, or DB-Library has executed a prepared Transact-SQL statement or statements.
73 Unprepare SQL ODBC, OLE DB, or DB-Library has unprepared (deleted) a prepared Transact-SQL statement or statements.
74 CursorExecute A cursor previously prepared on a Transact-SQL statement by ODBC, OLE DB, or DB-Library is executed.
75 CursorRecompile A cursor opened on a Transact-SQL statement by ODBC or DB-Library has been recompiled either directly or due to 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 percent of the maximum server memory, whichever is greater.
82-91 User Configurable (0-9) Event data defined by the user.
92 Data File Auto Grow Indicates that a data file was extended automatically by the server.
93 Log File Auto Grow Indicates that a data 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 run-time details of the SQL statement executed.
99 Reserved  
100 RPC Output Parameter Produces output values of the parameters for every RPC.
101 Reserved  
102 Audit Statement GDR Occurs every time a GRANT, DENY, REVOKE for a statement permission is issued by any user in SQL Server.
103 Audit Object GDR Occurs every time a GRANT, DENY, REVOKE for an object permission is issued by any user in SQL Server.
104 Audit Add/Drop Login Occurs when a SQL Server login is added or removed; forsp_addlogin and sp_droplogin.
105 Audit Login GDR Occurs when a Microsoft Windows® login right is added or removed; for sp_grantloginsp_revokelogin, and sp_denylogin.
106 Audit Login Change Property Occurs when a property of a login, except passwords, is modified; forsp_defaultdb and sp_defaultlanguage.
107 Audit Login Change Password Occurs when a SQL Server login password is changed.

Passwords are not recorded.

108 Audit Add Login to Server Role Occurs when a login is added or removed from a fixed server role; forsp_addsrvrolemember, and sp_dropsrvrolemember.
109 Audit Add DB User Occurs when a login is added or removed as a database user (Windows or SQL Server) to a database; for sp_grantdbaccess,sp_revokedbaccesssp_adduser, and sp_dropuser.
110 Audit Add Member to DB Occurs when a login is added or removed as a database user (fixed or user-defined) to a database; for sp_addrolemember,sp_droprolemember, and sp_changegroup.
111 Audit Add/Drop Role Occurs when a login is added or removed as a database user to a database; for sp_addrole and sp_droprole.
112 App Role Pass Change Occurs when a password of an application role is changed.
113 Audit Statement Permission Occurs when a statement permission (such as CREATE TABLE) is used.
114 Audit Object Permission Occurs when an object permission (such as SELECT) is used, both successfully or unsuccessfully.
115 Audit Backup/Restore Occurs when a BACKUP or RESTORE command is issued.
116 Audit DBCC Occurs when DBCC commands are issued.
117 Audit Change Audit Occurs when audit trace modifications are made.
118 Audit Object Derived Permission Occurs when a CREATE, ALTER, and DROP object commands are issued.

 

posted @ 2013-08-04 21:03 桦仔 阅读(...) 评论(...) 编辑 收藏