Post reply

Disk write every 2minutes

  • February 5, 2015 at 10:41 pm

    #303998

    Hello,

    during investigation problem with disk i found some issuse, that every 2minutes is writing on disk , it looks like to mdf file of database, but in almost 6-8milions Bytes / sec , it is about 1-2 sec , but every 2minutes... this is normal behaviour ? this is synchonyous writing to disk from memory? anybody has experience with this ?

    thanks

  • February 5, 2015 at 10:49 pm

    #1775949

    Probably the checkpoint process.

    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

  • February 5, 2015 at 11:01 pm

    #1775951

    yes i was thinking about this.. but almost for full io ?

    check images below

  • February 5, 2015 at 11:07 pm

    #1775952

    Yes, it's probably the checkpoint process.

    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

  • February 5, 2015 at 11:11 pm

    #1775953

    GilaMonster (2/5/2015)

    Yes, it's probably the checkpoint process.

    ok thank you, so It looks good, without any problem... because I investigated the error 833 with some heavy load to disk and it looks ok, but during backup sometimes shows this error 833.....do you have any good article about this ?

Viewing 5 posts - 1 through 5 (of 5 total)

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