There can be much more to it. Check other things like backups running, tape backups running. Are other applications running on the SQL server apart from SQL? Is that server also used for filesharing etc? add some performance monitor counters to see whether it is hard drive or memory or cpu etc (http://www.sql-server-performance.com and http://www.sql-server-performance.com/performance_monitor_tips.asp). Execute sp_who2 in query analyzer to see current processes. You can also use Profiler to monitor current activity on the server.

-----Original Message-----
From: chakry [mailto:mssqldba-ezmlmshield-x22544100.[Email address protected]
Sent: Monday, February 21, 2005 15:51 PM
To: LazyDBA Discussion
Subject: To find query that run for long time[Scanned]

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