Post reply

What does you actually mean by Logical Write?

  • October 3, 2012 at 4:44 am

    #262493

    Hi,

    I am aware that , when we actually write onto the disk that writing is know as physical write. But what is logical write?

  • October 3, 2012 at 4:49 am

    #1544797

    Logical is anything to do with memory, so a logical write is writing to the page in memory.

  • October 3, 2012 at 4:51 am

    #1544801

    so if that is logical then what is physical?

  • October 3, 2012 at 4:54 am

    #1544802

    The writing of the page from memory to disk.

    All writes happen in memory, then internal processes within SQL take the written to pages from memory and push them to disk.

  • October 3, 2012 at 4:56 am

    #1544803

    Ok. Thanks antony.

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

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