Search

Tuesday, July 26, 2011

How to read the trace file in query analyzer

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