Thanks Steve. 

The reason I ask is that we've got an application that is pushing the processors on the existing hardware and they need to decide either to just upgrade...

Have you tried creating individual maintenance plans for the two databases that fail? 

The only other thing that I can think of would be a space issue where it doesn't...

Andrew - in your original post you have \\9.1.1.14\F$ and in your last update you have \\9.1.1.14\l$.  Is this a typo or do you have both of those drive...

I don't have access to the servers, I provide trouble shooting help to the DBA group.  Kinda like L4 support, but with other responsibilities as well.  I'll definately be checking...

Thanks Shawn, this was exactly the info I was looking for.  I agree, let the db engine run on all processors.  The licensing is ok, we are per seat. 

I...

Thanks Tim, I know the settings you are talking about and they will set which processors sqlservr.exe can run on.  I guess I really need a way to assign processors to...

Thank you both for your replies.  I've turned on the processing log and have the information I need.  I'll try the clsCube method if I get some time to play around. ...

If you have another server, try restoring the database there and then back it again to compare the differences in time between the two servers.  That should help rule out...

Have you checked the Windows Event logs to see if you have a hardware error?  It could be as simple as a bad disk that is causing the degredation. 

Sorry to say we never got to the bottom of it.  After spending a fair amount of time on it we decided to continue using SQL Authentication. 

Don't install SP4 as you must have AWE configured to be addressing 8GB of RAM.  Read KB899761 for a description of the problem.

http://www.microsoft.com/sql/downloads/2000/sp4.asp

Warning: Microsoft has found an issue with...

Thank you both for your responses. This is what I had assumed but wanted to be sure.

Hi Kathi - this is exactly what I was looking for, thanks! Not sure how I missed it in BOL

PW - I'll see if I can get the connection string from the web.config file, but I don't have access to that server so there may be a delay. ...

There is a piece of the environment that I forgot to mention, sorry. The clients are making a TCP/IP connection from their workstations through .NET Webservices to an application...