Post reply

Read/Write Unit

  • September 24, 2008 at 8:58 pm

    #213026

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

  • September 24, 2008 at 9:04 pm

    #876766

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

  • September 25, 2008 at 12:24 am

    #876791

    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.

  • September 25, 2008 at 2:41 am

    #876829

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

  • September 25, 2008 at 8:44 am

    #877063

    "...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?

  • September 25, 2008 at 9:30 am

    #877100

    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/

  • September 25, 2008 at 11:32 am

    #877227

    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.;)

  • September 25, 2008 at 11:44 am

    #877236

    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).

    😎

  • September 26, 2008 at 3:37 am

    #877516

    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)

  • September 27, 2008 at 1:53 am

    #878051

    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