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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-18 : 09:44:40
|
| Eric writes "I have a stored procedure that runs completly in about 9 hours on my computer. At my client's site, the process is only 10% done in 24 hours. The computer at the client site has twice the memory (all other spec were the same) and neither computer was doing anything else but running this procress.What could be happening? What other settings should I compare between my environment and the target computer?Any advise would be appreciated.Regards,Eric" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-04-18 : 10:05:04
|
| Can you post your Stored procedure . it does takes hell of a time. by any chance do u use cursors in the sp??-------------------------------------------------------------- |
 |
|
|
Teroman
Posting Yak Master
115 Posts |
Posted - 2002-04-18 : 10:17:21
|
| Just a guess, but are the indexes different? That would make a hell of a difference to the speed. |
|
|
|
|
|
|
Different performance