noeld (9/4/2008)
The fact that you can are not using SP2 *is* a big deal.My only thought is that you should run a sqltrace at the times this happens and figure out what are the most expensive queries.
If these can be tweaked (add indexes, change the definition of an stored procedure, etc) you are fine.
good luck
I'm terribly sorry, but I mixed up the sql server version, it's actually 9.0.3175 which is post SP2, we had problems with service pack and erp on sql2000 before the upgrade.
Too tired and was not thinking straight 🙁
Maybe you have any other suggestions.