SQl Server 2005 Event ID 833

Posted on 2008-11-07
Last Modified: 2012-06-27

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?
Question by:shaun_mitchell
    LVL 11

    Expert Comment

    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.  

    Author Comment

    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.
    LVL 11

    Expert Comment

    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.

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Suggested Solutions

    On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now