Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2013-11-07 : 05:06:45
|
| I keep seeing the error message SQL Server has encountered x occurrence(s) of I/O requests taking longer than 15 secondsI 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
38200 Posts |
Posted - 2013-11-07 : 12:18:31
|
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
SQL Server has encountered x occurrence(s) of I/O