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
    xuka200308, Aug 14, 2006
    #2

  2. mmarovic Active Member

    Probably there was no enough space to expand the tempdb.
    mmarovic, Aug 14, 2006
    #2

  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.



    Luis Martin, Aug 14, 2006
    #2

  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
    xuka200308, Aug 14, 2006
    #2

  5. joechang New Member

    take a close look at the job, is there any significant difference by day
    joechang, Aug 14, 2006
    #2

  6. xuka200308 New Member

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

    thanks, All

    karen
    xuka200308, Aug 14, 2006
    #2

  7. mmarovic Active Member

    It must be, my guess is the amount of data processed is larger then other days.
    mmarovic, Aug 14, 2006
    #2

  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
    FrankKalis, Aug 14, 2006
    #2

  9. ranjitjain New Member

    You can run profiler to trace out what all other activities happen during sunday
    ranjitjain, Aug 15, 2006
    #2

  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
    xuka200308, Aug 15, 2006
    #2

  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.
    satya, Aug 16, 2006
    #2

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



    xuka200308, Aug 28, 2006
    #2

  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.
    satya, Aug 28, 2006
    #2

Share This Page