Use SQL Profiler.

P




-----Original Message-----
From: chakry
[mailto:mssqldba-ezmlmshield-x22544100.[Email address protected]
Sent: Monday, February 21, 2005 8:51 AM
To: LazyDBA Discussion
Subject: 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



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page