SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
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
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ranvir_2k
Posting Yak Master

United Kingdom
160 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?

tkizer
Almighty SQL Goddess

USA
36845 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
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.05 seconds. Powered By: Snitz Forums 2000