Duration Field in Profiler

I would like to monitor the script which takes more than 25 Sec. When i use filter i am not able to see the duration taken by the script. How can we get the time taken to execute the query.

My Requirement is simple:

Get all the scripts which takes more than 25 Sec(Time taken for execution of each statement is required).

Hello Senthil Prabhu,

When we are working with SQL Profiler we must keep in mind that we should not

OVERLOAD THE TRACES
There is no easy way to decide which events or data columns you need to capture as part of a trace. It
depends on the problem at hand, and it requires a good understanding of what events are available and
what each one of them does.

As the SQL Profiler is Most powerful yet complicate to analyst tool

When you connect to SQL Profiler you can create a template of T-SQL Duration. and more in Event Selection Tab you can customize the object name and other filter so you will find only desire details.

TSQL_DURATION
The TSQL_Duration template is used to capture all T-SQL statements submitted to SQL Server by
clients and their execution time. It groups the results by execution time duration.

Hope this will help you.

Thank you,
Sam

StackExchange Database Administrators Q#50027, answer score: 4