Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Stored Procedure is Slow but hte underlying code in not so s

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-05-23 : 09:01:51
solai writes "Hello:

I am fine tuning a process that currently runs for over 27 hours.

I put measurements and nailed down to the problematic storedprocedure that may have contributed to the overall slowdon.

Interestingly, if I simply ran the content of the procedure on the SQL Query Analyzer, it rans pretty fast - how do we fix this? Did they compile the procedure in a wrong way. Thank you.

-solai"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-05-23 : 09:04:16
http://sqlteam.com/forums/topic.asp?TOPIC_ID=66394

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -