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).
Best Answer
25 seconds in the Profiler GUI is 25,000 ms. Use WAITFOR DELAY to test it is working, eg