MSSQL 2008 Database is not responding well, getting Event Id 833 on windows 2008 R2

Dear experts,

We are running a website using MSSQL database on Windows 2008 R2, Now database is not responding on time.

Application some time is responding and sometimes not.

attached is the Event log. I am getting error SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [E:\DB_New\abcxxxx.mdf] in database [abcxxxx4]  

Heartily thanks for responding on this.

Regards
AK
Applogs.csv
LVL 1
aloknet21Asked:
Who is Participating?
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.

Ramkisan JagtapLead DeveloperCommented:
Hi,

This problem is caused by some issue in the operating system, by device drivers, by firmware, or by hardware that is used to support the devices to store SQL Server database and/or transaction log files. SQL Server records the time that it initiated an I/O request and records the time that the I/O was completed. If that difference is 15 seconds or more, this condition is detected. This also means that SQL Server is not the cause of a delayed I/O condition that this message describes and reports.

Please check the following microsoft support article:
http://support2.microsoft.com/kb/2137408
0
aloknet21Author Commented:
Hi,

thanks for the response, i have run windows update now.

This server is running on VMware, storage is mounted through Fibre SAN.

i have called Storage guys also to check but could not found any suspected logs.

Please suggest, if any other steps i can take to solve this issue.

Thanks
AK
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Are you running any Antivirus in that server?
Antivirus can lock SQL Server data and log files.

What about SQL Server Log? Have more information about this issue?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

aloknet21Author Commented:
I had removed Antivirus.

migrating database to a new VM now. will share sql log shortly.

Thanks
AK
0
aloknet21Author Commented:
sorry for delayed response but i had moved this VM to another storage using vmotion.

Increase RAM utilization for SQL services. it is working fine.

But still i could not understand what causes the issue.

i am attaching the log herewith.

Thanks
Ak
Applogs.csv
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
I'm afraid that now we can only guess since you made big changes.
0
aloknet21Author Commented:
yes you are right, since it was very urgent to save production time, so i had taken this steps.

I had updated patches, Drivers, Removed Antivirus etc.. but could not succeed.

Have you looked any suspected things in logs?

Thanks
AK
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
It's too big.
Can you send it in text format and point me more or less the date and time where you got the problem?
0
aloknet21Author Commented:
Hi Sorry for delayed response!

Below are the error.

Information      9/26/2014 8:27      MSSQLSERVER      833      Server      SQL Server has encountered 14 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\Databaselogfile\xxxx_log.ldf] in database [xxxx4] (7).  The OS file handle is 0x0000000000000794.  The offset of the latest long I/O is: 0x0000001b487000
Information      9/26/2014 8:08      MSSQLSERVER      833      Server      SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [E:\DB_New\xxxx.mdf] in database [xxxx] (7).  The OS file handle is 0x000000000000077C.  The offset of the latest long I/O is: 0x00000d8e65a000
Information      9/26/2014 8:08      MSSQLSERVER      833      Server      SQL Server has encountered 11 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\Databaselogfile\xxxx_log.ldf] in database [xxxx] (7).  The OS file handle is 0x0000000000000794.  The offset of the latest long I/O is: 0x0000001708a000
Information      9/26/2014 8:03      MSSQLSERVER      833      Server      SQL Server has encountered 15 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\Databaselogfile\xxxx_log.ldf] in database [xxxx] (7).  The OS file handle is 0x0000000000000794.  The offset of the latest long I/O is: 0x00000012bbd000
Information      9/26/2014 8:01      MSSQLSERVER      833      Server      SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [E:\DB_New\xxxx.mdf] in database [xxxx] (7).  The OS file handle is 0x000000000000077C.  The offset of the latest long I/O is: 0x00000d914b0000

Thanks
AK
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
The error log it's from 2 weeks ago. You still have the problem?
Anyway it's I/O problem so you should have your VM disk checked.
0

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

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.