Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am not a DBA so please be patient with me...

Is it possible to turn on a trace on SQL Server which will tell me any SQL statement that takes longer than 2 seconds to execute, when it happened and what the SQL was? Is it possible to set the time to 2, 3 , 4 , whatever... ?

Thanks

share|improve this question

1 Answer 1

up vote 5 down vote accepted

Yes.

In SQL Server Profiler, you can filter on "Duration"

enter image description here

(This is from the "Standard (default)" template on SQL Server 2012 RC0 Profiler)

share|improve this answer
    
+1 I had no idea that even existed. Nice answer! –  BryceAtNetwork23 Mar 7 '12 at 13:18

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.