searching for specific Duration in Profiler | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

searching for specific Duration in Profiler

Is there a way to search on specific Duration thresholds, such as >1000 in a trace file? I know you can filter to initially trace on specific duration based on condition, but what about searching in a created trace file?
You could use Profiler#%92s Trace Wizard to run the "TSQL By Duration" trace. You can specify the length of the long running queries you are trying to identify (such as over 1000 milliseconds), and then have these recorded in a log for you to investigate later.
Not sure how you can analyze the existing file, you might use the fn_trace_gettable() function to load the trace data into a table for analysis. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
I think you’re right, Thanks!
Post back the results if you have got correct information, that helps other too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>