SQL Server tracks field item encoding and interpretation for each event

Source: Internet
Author: User

COLUMN_ID like the following table:
1 TextData The text value associated with the event class captured within the trace.
2 BinaryData binary value associated with the event class captured in the trace.
3 The database ID specified by the DatabaseID. DB statement, or the default database ID if no use is issued for the given connection.
You can use the DB_ID function to determine the value of a database.

4 TransactionID The system-assigned transaction ID.
5 reserved
6 Ntusername Microsoft Windows nt® User name.
7 Ntdomainname The Windows NT domain to which the user belongs.
8 Clienthostname The name of the client computer that originated the request.
9 ClientProcessID The ID of the client computer that is assigned to the process, and the client application is running in that process.
ApplicationName the name of the client application that created the connection to the instance of SQL Server. The column is populated with the values passed by the application instead of the program names that are displayed.
The SQL Server login name of the Sqlsecurityloginname client.
The SPID SQL Server-assigned server process ID associated with the client.
The total elapsed time (in milliseconds) spent by the Duration event. The hash Warning event does not populate the data column.
StartTime the time at which the event was started (when available).
The time at the end of the EndTime event. The column that initiates the event class (such as sql:batchstarting or sp:starting) is not populated. The hash Warning event also does not populate the column.
Reads the number of logical disk reads performed by the server on behalf of the event. The lock:released event does not populate the column.
Writes the number of physical disk writes performed by the server on behalf of the event.
The total CPU time (in milliseconds) used by CPU events.
Permissions a bitmap that represents permissions, used by security audits.
The severity level of the Severity exception error.
The EventSubClass event subclass type. The data column for all event classes is not populated.
ObjectID the system-assigned object ID.
Success attempt to use permissions succeeded; used by auditing.
1 = Success
0 = Failed

IndexID the index ID on the object affected by the event. To determine the index ID of an object, use the indid column of the sysindexes system table.
Integerdata the integer value associated with the event class captured in the trace.
SERVERNAME is tracking the SQL Server instance name (ServerName or servername\instancename).
The event class type that is being logged by EventClass.
ObjectType the object type (such as a table, function, or stored procedure).
Nestlevel the nesting level on which the stored procedure is executing. See @ @NESTLEVEL.
State of the server when an error occurs in the.
Error number.
The lock mode of the lock is acquired by mode. The lock:released event does not populate the column.
Handle the handle of the object referenced in the event.
The name of the object to which the ObjectName is accessed.
The database name specified in the DatabaseName use database statement.
The logical name of the file name to which the filename was modified.
PNS ObjectOwner The owner ID of the referenced object.
The Targetrolename statement is the name of the database-scoped role or server-scoped role targeted.
TargetUserName the user name of an operation target.
The SQL Server database user name for the DatabaseUserName client.
Loginsid The security identification Number (SID) of the logged-on user.
Targetloginname the login name of an operation target.
Targetloginsid is the login SID for an operation target.
Columnpermissionsset column-level permission state, used by security audits.

SQL Server tracks field item encoding and interpretation for each event

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.