[thelist] [SQL] Slow queries/sp's
Joshua Olson
joshua at waetech.com
Tue Apr 12 09:26:24 CDT 2005
Hi list, I need a few pointers.
On a web project, we are running a few sp's to do a bunch of processing.
Most of the times, the SP's take less than a minute to execute. Sometimes,
as of late, the sp's are taking over 20 minutes to complete.
I have two theories.
1. Something is stealing CPU cycles from the SQL Server 2k instance.
2. There is a race condition somewhere in the web of tables and table
access.
It's not feasible to monitor the server manually 24/7. Anybody have luck
with tools to help track down what's going on?
TIA!
<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com/service_areas/
706.210.0168
More information about the thelist
mailing list