After reviewing the previous suggestions to add more LUN's to the environment, I decided to test spreading one database across two LUNS, then three and four.

The results were very definitive....

Thanks everyone for the insight on this issue.

I have spoken to the SAN Administrator(s) and we have decided to try the multiple LUN approach and see if that alleviates some...

Thanks for the explanation, however SQL Server is currently addressing the Full 5 GIG as the AWE option is enabled on it.

As for Windows 2000 Advanced Server, I will look...

What would this do for me exactly?

No I cannot confirm that. I have the /PAE switch in my boot.ini and that is it.

I have SQL Server fixed on using Physical Memory only and...

My Server has a total of 6 GIG of RAM with 1 for the OS and SQL Server is fixed on 5 GIG.

The Avg. Disk Queue length was 86.

The disks are all working properly.

Any other clues?

Thanks Steve. The one thing that has not occurred at this point is an Open call to Microsoft since we have been dealing so much on the Hardware side.

I...

Nothing (Seriously Nothing) has changed on the SQL Server itself. There was a firmware upgrade on the SAN that Compaq/HP swears would not cause any of the issues, but...

I think the idea of using an IM type of environment would certainly be of benefit.

I would prefer a more collaborative social place for DBA's where they could bounce questions...