stale read & lost write

  • Hi Experts,

    Can anyone please explain what is stale read and lost write.

    TIA

  • Lost write is when SQL writes data the OS returns that the write was successful, but it didn't actually get written to the media because of some underlying failure.

    A stale read is kinda the opposite, the OS returns that read was successful, but an old copy of the data from a buffer was returned (that does not match the newer data that is on the media).

    Both could indicate driver or hardware issue.

  • Thank you very much jamie

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

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