To find query that run for long time

To find query that run for long time

 

  

Dear All,
For past few days I found our application is fast for sometime, and suddenly
goes down.
I think there must be few queries which are running for long time.
Can anybody tell me to find out the query which is running for long time?


Thanks & Regards,
Chakry
Mobile: +91 98402 57095


MS Sql Server LazyDBA home page