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 |
|
kappa02
Yak Posting Veteran
65 Posts |
 Posted - 2004-11-23 : 10:49:47
|
| In the past three weeks our SQL 2K Server(8.00.760) on windows 2003 will just hang & needs to be re-booted, in the Event Viewer the message :“The driver for device \Device\Harddisk1\DR1 delayed non-paging Io requests for 0 ms to recover from a low memory condition."Appears before the system hangs. Do I need to change the settings in sp_configure (Min Server Memory, Max Server Memory, etc) or dose the page file option needs to be adjusted (increase/decrease). Information on what is causing the event & how to prevent it is greatly appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-23 : 14:02:20
|
| It sounds like you have a memory bottleneck. So you'll need to add memory to fix it.Tara |
 |
|
|
Docyit
Starting Member
1 Post |
Posted - 2005-08-18 : 12:17:40
|
| I found the solution to this condition. Check you Performance settings. Make sure the Memory usage is set to Programs and NOT system cahce. Mine was system cache and when I ran Backup Exec Restores I would drop to 1.5K free and get the Event 119 errors. After changing the setting to give Programs preference I never dropped below 500K. Hope this helps someone else as the tracking on this problem was very thin. |
|
|
|
|
|
|
Server Keeps Hanging