Databases Reference
In-Depth Information
A workload or workload file basically contains a series of T-SQL statements. A T-SQL script is
an example of a workload file. Because trace data also contains a series of T-SQL statements
as a part of event data (as TextData Column), they are also used as workloads. Thus, a
T-SQL script, trace file
(.trc
or
.xml
), trace table, all can be considered as workload. In
other words, a trace file is also a workload file. This workload can be used to re-run on a
database for workload or performance analysis. Usually, a workload file is provided as input
file to Database Engine Tuning Advisor (DTA) for a tuning session. You will learn more about
Database Engine Tuning Advisor in
Chapter 2
,
Tuning with Database Engine Tuning Advisor
.
Commonly-used event classes
The following list gives brief descriptions of commonly used event classes:
F
Audit Login
: This event occurs when a user connects and logs in to SQL Server
F
Audit Logout
: This event occurs when a users disconnects and logs out from
SQL Server
F
RPC:Starting
: This event occurs when a Remote Procedure Call (RPC)
starts executing
F
RPC:Completed
: This event occurs when a Remote Procedure Call (RPC)
completes its execution
F
SQL:BatchStarting
: This event occurs when a T-SQL batch starts executing
F
SQL:StmtStarting
: This event occurs when a statement inside a T-SQL batch
starts executing
F
SQL:StmtCompleted
: This event occurs when a statement inside a T-SQL batch
completes its execution
F
SQL:BatchCompleted
: This event occurs when a T-SQL batch completes
its execution
F
SP:Starting
: This event occurs when a stored procedure starts executing
F
SP:StmtStarting
: This event occurs when a statement inside a stored procedure
starts executing
F
SP:StmtCompleted:
This event occurs when a statement inside a stored
procedure completes its execution
F
SP:Completed
: This event occurs when a stored procedure completes its execution
Commonly-used data columns
The following list gives brief descriptions of commonly used event classes:
F
ApplicationName
: This data column represents the name of the client application
causing a trace event to occur
F
DatabaseID
: This data column represents the internal system assigned ID of the
database for which a trace event occurs
Search WWH ::
Custom Search