Read/Write Unit

  • Comments posted to this topic are about the item Read/Write Unit

  • Is it 8K page for each read or write? Please correct me if I am wrong.

  • Hi, u r absolutely right. Read is the number of logical disk reads in 8KB pages. For example , if u have a read of 30, then actually SQL server reads 245760 (30*8*1024) Bytes of data.

  • I'm glad 60% of people were also wrong 😀

  • "...What are the units of the values...?"

    Your question is about the units, and I think the UNITS are BYTES (as well if you talk about the units as gallons, liters, pounds, etc).

    Am I wrong?

  • I think that today’s question wasn’t a good one. Since the answer is number of 8KB pages there was no correct choice given to us. Bytes much more fits then Scalar Value but it is also not a good answer.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • Actually, I didn't know the "UNIT" of R/W in profiler. But, when I thought about STATISTICS_IO, I picked up the correct answer.;)

  • Adi Cohn (9/25/2008)


    I think that today’s question wasn’t a good one. Since the answer is number of 8KB pages there was no correct choice given to us. Bytes much more fits then Scalar Value but it is also not a good answer.

    Adi

    Bytes doesn't fit better. The value is the number of 8KB pages. This is a scalar value.

    Perhaps the question could have been written differently, but overall, it did inspire discussion and research (and hopefully add to everyones knowledge).

    😎

  • Hi Ric,

    You r right abt the Unit. This is like gallon, meter, gram etc. But actually logical read and write has no unit, they are only numbers. (Even not bytes)

  • Easy but good questions ......

Viewing 10 posts - 1 through 9 (of 9 total)

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