SQL Server Performance Forum – Threads Archive
why SQL hang on every sunday?
Hi Allwe 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
Probably there was no enough space to expand the tempdb.
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
take a close look at the job, is there any significant difference by day
nothing is dirrerent. i asked hardware team to check it. thanks, All karen
It must be, my guess is the amount of data processed is larger then other days.
Just a thought. Any maintenance stuff running on Sunday? Reindexing probably? —
Frank Kalis
Moderator
Microsoft SQL Server MVP
Webmaster:http://www.insidesql.de
You can run profiler to trace out what all other activities happen during sunday
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.
]]>