SQL Server Performance

why SQL hang on every sunday?

Discussion in 'Performance Tuning for Hardware Configurations' started by xuka200308, Aug 14, 2006.

  1. xuka200308 New Member

    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
  2. mmarovic Active Member

    Probably there was no enough space to expand the tempdb.
  3. Luis Martin Moderator

    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.



  4. xuka200308 New Member

    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
  5. joechang New Member

    take a close look at the job, is there any significant difference by day
  6. xuka200308 New Member

    nothing is dirrerent. i asked hardware team to check it.

    thanks, All

    karen
  7. mmarovic Active Member

    It must be, my guess is the amount of data processed is larger then other days.
  8. FrankKalis Moderator

    Just a thought. Any maintenance stuff running on Sunday? Reindexing probably?

    --
    Frank Kalis
    Moderator
    Microsoft SQL Server MVP
    Webmaster:http://www.insidesql.de
  9. ranjitjain New Member

    You can run profiler to trace out what all other activities happen during sunday
  10. xuka200308 New Member

    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
  11. satya Moderator

    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.
  12. xuka200308 New Member

    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".



  13. satya Moderator

    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.

Share This Page