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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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... ?


share|improve this question
up vote 5 down vote accepted


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! – Aaron Mar 7 '12 at 13:18

Your Answer


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.