Post reply

Insert write delay

  • March 10, 2009 at 6:07 am

    #206768

    SQL Server 2005 SP2

    Database RecoveryModel Simple.

    There occours a daily problem with insert records with very slow performance.

    1 Record insert takes until 3 sec. this happens only between 03.00 - 04.00 in the nigth

    Rest of the time we had no problems with the insert statments.

    I found no error entries in the log at this time ...

  • March 10, 2009 at 1:16 pm

    #957030

    Check what jobs are running at that time.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 10, 2009 at 4:13 pm

    #957134

    [font="Verdana"]Backups? Virus scan? Database Maintenance?[/font]

  • March 11, 2009 at 7:25 am

    #957460

    i changed today the backup jobs to an other time it was 1 Database transaction log backup at this time.

    hoppefully this will help.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply