Average Record Size

[Former Member]

Hi all,

We're resizing our landscape for a new SAN. We'd like to know the average record size within the database? I was reading it's 8k but that seems too small. We're thiking more around 64kb blocks. Anyone knows what's SAP preferred method?

Thank you,

Samer

[Former Member]

Sorry, but you are not giving us enough details to help you. Do you want to know about I/O sizes of a database? The average record size is much smaller than 8kb, but for example the oracle block size is 8kb. And oracle always reads at least one block per I/O. But you didn't mention which database you have, nor the operation system you use.

Best regards, Michael

[Former Member]

hi and sorry for not completely posting the required info. this a sql 05/ecc windows 2004.

thank you,

Samer

[Former Member]

just noticed i typed 2004 instead of Windows 2003

[Former Member]

Hi sameer

M not sure if this would be the answer to your question but this could certainly help you in what you are trying to do. Please check the following links:

http://www.saptechies.com/faq-oracle-performance/

hope this helps

regards

Chen

[Former Member]

Thanks Chetan for the document, but I'm looking for a more specific answer on a SQL platform.

Any thoughts everyone?