Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL Server has encountered x occurrence(s) of I/O
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

United Kingdom
180 Posts

Posted - 11/07/2013 :  05:06:45  Show Profile  Reply with Quote
I keep seeing the error message SQL Server has encountered x occurrence(s) of I/O requests taking longer than 15 seconds

I also have this message when SQL Server starts A significant part of sql server process memory has been paged out. This may result in a performance degradation.

Could enabling lock pages in memory put less pressure on the disk and hence possibly remove the I/O error messages appearing?

Almighty SQL Goddess

38200 Posts

Posted - 11/07/2013 :  12:18:31  Show Profile  Visit tkizer's Homepage  Reply with Quote
You do need to setup LPIM, but I doubt it's going to resolve such a severe IO issue. Are you drivers and firmware up to date for the entire IO subsystem? That's typically the first place you start. Usually servers are a few revisions behind. If that doesn't work, then you need to get in touch with the disk admins. You could run an ETW trace to figure out where in the stack the issue is. It'll tell you if it's in the OS or past the storport driver. This is complicated stuff and generally requires assistance from Microsoft.

Tara Kizer
SQL Server MVP since 2007
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000