Post reply

CHECKDB on Disk to Disk Replicated DB

  • July 16, 2014 at 3:57 am

    #288675

    Hi Experts,

    Does CHECKDB issued on db having disk to disk replication causes high IO??

  • July 16, 2014 at 4:50 am

    #1729782

    Checkpoints are issued regularly by SQL Server to flush dirty pages to disk. You can manually issue them as we'll.

    In terms of IO, it depends on the rate of changes in your database. If you have many in a short period and issue a checkpoint, this definitely can cause io to rise. However, you'd seem the same IO from the automatic checkpoints.

    For disk to disk replication, do you mean block level movement from the OS or SAN?

  • July 16, 2014 at 5:59 am

    #1729806

    Thanks Steve...I am really really sorry..what i wanted to type to CHECKDB??

    How can i edit the heading of the post?

  • July 21, 2014 at 12:21 pm

    #1731154

    Edited.

    There should be an edit button at each post you can edit.

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

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