Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Read/Write Unit Expand / Collapse
Author
Message
Posted Wednesday, September 24, 2008 8:58 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 3, 2012 5:49 AM
Points: 418, Visits: 365
Comments posted to this topic are about the item Read/Write Unit
Post #575687
Posted Wednesday, September 24, 2008 9:04 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 10, 2014 8:13 AM
Points: 1,278, Visits: 2,204
Is it 8K page for each read or write? Please correct me if I am wrong.
Post #575689
Posted Thursday, September 25, 2008 12:24 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 3, 2012 5:49 AM
Points: 418, Visits: 365
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.
Post #575725
Posted Thursday, September 25, 2008 2:41 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, December 9, 2013 3:40 AM
Points: 58, Visits: 153
I'm glad 60% of people were also wrong :D
Post #575777
Posted Thursday, September 25, 2008 8:44 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, August 31, 2014 6:28 AM
Points: 1,426, Visits: 342
"...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?



Post #576066
Posted Thursday, September 25, 2008 9:30 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:28 AM
Points: 2,114, Visits: 5,502
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/
Post #576117
Posted Thursday, September 25, 2008 11:32 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 1:26 PM
Points: 405, Visits: 1,431
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.;)
Post #576270
Posted Thursday, September 25, 2008 11:44 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:36 PM
Points: 20,738, Visits: 32,522
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).




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #576280
Posted Friday, September 26, 2008 3:37 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 3, 2012 5:49 AM
Points: 418, Visits: 365
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)
Post #576635
Posted Saturday, September 27, 2008 1:53 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,406, Visits: 1,400
Easy but good questions ......


Post #577275
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse