Thread: Unusual high query execution time
View Single Post
  #9 (permalink)  
Old 08-26-10, 10:24
shammat shammat is offline
Registered User
  
Join Date: Nov 2003
Posts: 2,407
Quote:
Originally Posted by rahul_pat1748 View Post
Regularly the query executes in a minute and sometime it peaks at takes 35-40 mins. We don't know, on which day will it take long time to run and on that day put the trace on. Its completely unexpected behavior and no pattern applies.
Then you need to enable tracing every time the statement is run.
Reply With Quote