Thanks for everyone's responses. What I failed to include in my original post is that we are running SQL Server 2005 on an Egenera Bladeframe environment which is suppose...

I will definitely try to run UPDATE STATISTICS With Fullscan. I had a quick question, this is the second time somebody mentioned to run the following 2 commands.

1. DBCC...

The strange thing is, none of this performance issues occurred on SQL 2000. It had it's own issues, but nothing this major. Is there something that may have...

Here are some numbers:

Data drive only

Avg. Disk sec/read - 0.769

Avg. Disk sec/Write - 0.208

Avg. Disk sec/Transfer - 0.767

% Idle Time - 0.000

The most interesting...

Thanks for the information. We have run performance monitor on the server and profiler. Unfortunately, the PeopleSoft application has tons of noise. We ended up using the...

The main issue is that our I/O is going through the roof. It has also been intermittent. The users use nVision as there reporting tool which is a...

The "Lock Pages in Memory" policy.

Thanks

Can I add another question to this?

What are the benefits when you turn this on?

I should be all set with this issue.  I needed to disable and re-setup Log shipping.