Read/Write Unit

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Arup Chakraborty » Read/Write Unit

Read/Write Unit

Rate Topic

Display Mode

Topic Options

Author

Message

arup chakraborty

Posted Wednesday, September 24, 2008 8:58 PM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 03, 2012 5:49 AM
Points: 418, Visits: 365

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

Post #575687

Vivien Xing

Posted Wednesday, September 24, 2008 9:04 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 7:19 AM
Points: 1,279, Visits: 2,191

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

Post #575689

arup chakraborty

Posted Thursday, September 25, 2008 12:24 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 03, 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

daft

Posted Thursday, September 25, 2008 2:41 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 7:29 AM
Points: 58, Visits: 151

I'm glad 60% of people were also wrong :D

Post #575777

Ric Sierra

Posted Thursday, September 25, 2008 8:44 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, June 14, 2013 6:25 PM
Points: 1,422, Visits: 254

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

Adi Cohn-120898

Posted Thursday, September 25, 2008 9:30 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:47 PM
Points: 2,023, Visits: 4,948

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

Wildcat

Posted Thursday, September 25, 2008 11:32 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 10:10 PM
Points: 307, Visits: 1,390

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

Lynn Pettis

Posted Thursday, September 25, 2008 11:44 AM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:17 PM
Points: 21,832, Visits: 27,855

Adi Cohn (9/25/2008)

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

Cool

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

arup chakraborty

Posted Friday, September 26, 2008 3:37 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 03, 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

Anipaul

Posted Saturday, September 27, 2008 1:53 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:01 AM
Points: 4,815, Visits: 1,343

Easy but good questions ......

Post #577275

« Prev Topic | Next Topic »

Permissions