TABLE 1: Three Wizard-Generated Sample Traces
Worst-performing queries	Identifying the cause of a deadlock	Profiling stored procedure performance for a database
Parameters include database to cover, applications to trap, and minimum duration of query to capture	Parameter: All or specific database to check for deadlocks	Parameters include all or specific database and all or specific stored procedure
Events:	Events:	Events:
RPC:Completed	RPC:Starting	SQL:BatchCompleted
SQL:BatchCompleted	SQL:BatchStarting	SQL:BatchStarting
Data Columns:	Lock:Deadlock	SP:Starting
Groups:	Lock:Deadlock Chain	SP:Completed
Duration	Data Columns:	SP:StmtStarting
Columns:	Groups:	SP:StmtCompleted
Event Class	Event Class	Data Columns:
Text	Columns:	Groups:
CPU	Object Id	Connection Id
Application Name	Event Sub Class	Columns:
SQL User Name	Connection Id	Event Class
NT User Name	SPID	Object Id
Filters:	Text	Text
Duration:	Server Name	Transaction ID
Minimum:1000	Database Id	Duration
	Index Id	CPU
	Application Name	Reads
	SQL Use Name	Writes
	Start Time	Start Time
	Integer Data	End Time
	Binary Data	Application Name
		Server Name
		Database Id
		SPID
		Filters:
		Database Id:
		Value:6