Hi All we have the server that hang on almost sunday everning. it's SQL Server standard edition with SP4 on windows 2003. the following is the error messages that caused server hang. I/O error 1450(Insufficient system resources exist to complete the requested service.) detected during write at offset 0x000000f0bb4000 in file 'E:... empdb.mdf'.. Error: 823, Severity: 24, State: 4 ..... could anyone has similar exeperience? thanks, karen
And could be because you have a scheduled job to run on sunday. Review all jobs. Luis Martin Moderator SQL-Server-Performance.com All in Love is Fair Stevie Wonder All postings are provided “AS IS†with no warranties for accuracy.
sorry, all i should tell you all that the job runs everyday. and there is not another job running at the same time. the server hungs every sunday. it works fine on weekday. nothing special on sunday evening. karen
Just a thought. Any maintenance stuff running on Sunday? Reindexing probably? -- Frank Kalis Moderator Microsoft SQL Server MVP Webmaster:http://www.insidesql.de
the job is doing optimizations. there is nothing different by day. it runs fine except on the weekend. we are working on it. hope it's hardware issue as the hardware team is trying to fix it. karen
Do you have any batch jobs to load the data specifically on Sundays, that may give some clue if so. KBAs http://support.microsoft.com/kb/274310/EN-US/ http://support.microsoft.com/kb/219756/EN-US/ ..fyi. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing.
thanks, All our NW team didn't fix this problem. the SQL Server still hang on sunday morning. anyone has any idea with this? the job is doing "integrity checking".
Have you referred to the KBAs above? Also check the Hardware in thsi case, if the database has outgrown since last year then try to run integrity checks on bigger tables seperately. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing.