SQl Server 2005 Event ID 833


I'm currently running an Active / Passive SQL Server 2005 cluster. I have around 30 databases running on the active node and yesterday I started seeing the following events in the Event Viewer.

Event Type:      Information
Event Source:      MSSQLSERVER
Event Category:      (2)
Event ID:      833
Date:            11/7/2008
Time:            1:28:35 PM
User:            N/A
SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [PATH TO THE DATA FILE] in database [MY DATABASE] (11).  The OS file handle is 0x00000BB0.  The offset of the latest long I/O is: 0x0000035b85c000

This is running on Server 2003 Enterprise 32bit. I have SQL Server 2005 SP2 installed.

They seem to be  at odd times and at least once it seems to have caused the cluster to fail over. I've upgraded the drivers for the HP EVO cards but I still got this error a couple of hours later. I've read about some CPU clock timing slipage and I'm still investigating that.

Does anyone else know what might be causing this or could possible give me some direction to start looking?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I would look at the the I/O throughput on your storage and see if you are running in a bottleneck.  Are you databases very busy?  What type of storage are you using.  
shaun_mitchellAuthor Commented:
I will have our SAN expert take a look at the throughput and I will put on some monitoring on the SQL server. I've looked at it once already and I didn't noticed anything. Our database aren't overly large, they are used on a frequent basis but nothing that I haven't seen before. We are using an HP EVA 4400 SAN.
You may also want to check you HBA's for errors.  Are you using QLOGIC or Emulex HBA's?  There is software that comes with each that can show you the HBA activity as well as any errors that are being generated.
shaun_mitchellAuthor Commented:
I think I have found a solution.

I've updated the Emulex Storport driver using HP ProLiant Support Pack  8.11 and I installed the following Microsoft hotfix.


I need to let this run for  a couple of days to make sure it has been resolved.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.