select
spid,
StartTime,
Endtime,
Textdata,
duration,
DatabaseName,
ApplicationName
from
fn_trace_gettable ( 'D:\Temp\Performance_Deadlock_1.trc' , 1)
where
DatabaseID='12' and duration >10000
====================================================================================
Open the query analyzer and execute the above script.you can choose the field you want to analyze and give the path of the trace file.
No comments:
Post a Comment