TABLE 1: Three Wizard-Generated Sample Traces
Worst-performing queriesIdentifying 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 captureParameter: All or specific database to check for deadlocksParameters include all or specific database and all or specific stored procedure
Events:Events:Events:
RPC:CompletedRPC:StartingSQL:BatchCompleted
SQL:BatchCompletedSQL:BatchStartingSQL:BatchStarting
Data Columns:Lock:DeadlockSP:Starting
Groups:Lock:Deadlock ChainSP:Completed
DurationData Columns:SP:StmtStarting
Columns:Groups:SP:StmtCompleted
Event ClassEvent ClassData Columns:
TextColumns:Groups:
CPUObject IdConnection Id
Application NameEvent Sub ClassColumns:
SQL User NameConnection IdEvent Class
NT User NameSPIDObject Id
Filters:TextText
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