[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