SQLServerCentral.com / Article Discussions / Article Discussions by Author / Discuss content posted by Arup Chakraborty / Read/Write Unit / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 31 Mar 2015 16:48:24 GMT20RE: Read/Write Unithttp://www.sqlservercentral.com/Forums/Topic575687-1391-1.aspxEasy but good questions ......Sat, 27 Sep 2008 01:53:19 GMTAnipaulRE: Read/Write Unithttp://www.sqlservercentral.com/Forums/Topic575687-1391-1.aspxHi 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)Fri, 26 Sep 2008 03:37:57 GMTarup chakrabortyRE: Read/Write Unithttp://www.sqlservercentral.com/Forums/Topic575687-1391-1.aspx[quote][b]Adi Cohn (9/25/2008)[/b][hr]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[/quote]Bytes doesn't fit better. The value is the [b]number[/b] 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).:cool:Thu, 25 Sep 2008 11:44:08 GMTLynn PettisRE: Read/Write Unithttp://www.sqlservercentral.com/Forums/Topic575687-1391-1.aspxActually, I didn't know the "UNIT" of R/W in profiler. But, when I thought about STATISTICS_IO, I picked up the correct answer.;)Thu, 25 Sep 2008 11:32:55 GMTWildcatRE: Read/Write Unithttp://www.sqlservercentral.com/Forums/Topic575687-1391-1.aspxI 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. AdiThu, 25 Sep 2008 09:30:33 GMTAdi Cohn-120898RE: Read/Write Unithttp://www.sqlservercentral.com/Forums/Topic575687-1391-1.aspx"...What are the [b]units [/b]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?Thu, 25 Sep 2008 08:44:11 GMTRic SierraRE: Read/Write Unithttp://www.sqlservercentral.com/Forums/Topic575687-1391-1.aspxI'm glad 60% of people were also wrong :DThu, 25 Sep 2008 02:41:22 GMTdaftRE: Read/Write Unithttp://www.sqlservercentral.com/Forums/Topic575687-1391-1.aspxHi, 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.Thu, 25 Sep 2008 00:24:55 GMTarup chakrabortyRE: Read/Write Unithttp://www.sqlservercentral.com/Forums/Topic575687-1391-1.aspxIs it 8K page for each read or write? Please correct me if I am wrong.Wed, 24 Sep 2008 21:04:33 GMTVivien XingRead/Write Unithttp://www.sqlservercentral.com/Forums/Topic575687-1391-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/Performance/64303/">Read/Write Unit</A>[/B]Wed, 24 Sep 2008 20:58:24 GMTarup chakraborty