Link to home
Create AccountLog in
Avatar of ryan80
ryan80

asked on

Finding average read size for a server.

I am currently running some simulations for a future database to see what kind of storage requirements I will need. I am working with a subset of the full database, and am trying to get a profile of the data and see what the average read size is. I know that I will need close to 2 GB/sec and about 40,000 IOPS, but depending on the average read size, that could make a big difference in what I will need.
ASKER CERTIFIED SOLUTION
Avatar of Armand G
Armand G
Flag of New Zealand image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of ryan80
ryan80

ASKER

Thanks for the link. So looking through the information there, it looks like I can use diskpart to define what the block size will be for the partition?
It's for the volume alignment of your disk and yes, you can define it but you need to be careful.

You can use SQLIO/ Windows System Monitor tool  for the testing  average read size of disks on your first question.
Avatar of ryan80

ASKER

Thank you, very informative.