Thank you all for the responses, it's nice to know that I'm not the only one in this posistion.

Good thing is, we all have this wonderful site to share questions...

Please try reinstalling and rebooting the machine and check if the issue still persists

If you are looking for the gui interface, OEM (Oracle Enterprise Manager) should be quite easy to understand.

No need, just install SP2

We had to install new raid controllers and hdd's.

We have 2 mirror servers, so to reduce the risk and downtime we started on the one (passive, duh!) and after confirming...

Sorry if I post what you already know.

I can not stress enough how important the testing phase is. You have to use the exact same version of SQL, Windows etc....

This was during peak activity.

I am busy setting up a scheduled monitor for the next week or so to determine this 100%

Great stuff!

Thanks

After hours of researching and sweating I can safely say that this is an IO issue. I believe the partitioning was done incorrectly.

I have come upon a VERY interesting link...

Thanks a lot.

I will review a bit!

Regards

Apologies about the joke. I have edited it accordingly.

I have read a little about the CXPACKET wait type.

Now this is one of our top waits.

Would increasing the MDOP to 4 help this out?

I have requested from one of...

Thanks for the update.

I would love to have some one's email address, as I believe this is going to be a looooong problem.

I've been put in an environment that was...

Thank you so much.

Unfortunately, our client is not willing to pay what they need to.

That's why we have to make use with what we have

Hi Gail

Thanks for the response.

Luckily I know that the logs and data should be seperated.

So, in conclusion, the issue is with the hdd's? I believe they are running at 7200rpm.

These...