Actually I reset sp_configure locks, o and rebooted the server and so far... so good.  I will read the link and keep these suggestions close.  Thanks!

Sorry... as far as the article, I did try those solutions yesterday and it actually made it worse...

I did read that article.  I ran sp_configure locks, 0 and I won't know if the job fails again until this evening when they try again.  So far... no errors. ...

I really appreciate the suggestions. This database is just too huge and growing rapidly.  Can you give me any tips on views?  Or possible links?  I still consider myself a newbie and...

sorry 2000

Thanks to all!  I really appreciate the help!

I certainly appreciate all the help

Thanks.

The database/server slows down to a horrible crawl. Today it was like that for over an hour.  It'll freeze trying to get into Enterprise manager.  We are a bank and can't...

Is it possible to link servers and place the tempdb on the other server?  Thanks a bunch for all your help.

I guess I'm looking for tips to increase performance on this large database that will probably be increasing in size on a regular basis.  Right now the tempdb is at 500MB and...

What is the best way to find out what is happening to the code?  There is a siebel app that pulls user queries from the database.