We help IT Professionals succeed at work.

Finding average read size for a server.

Medium Priority
325 Views
Last Modified: 2012-06-21
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.
Comment
Watch Question

Senior Developer
CERTIFIED EXPERT
Commented:
While the server is running, there are few tools you can use and you should try out the tools as described by Microsoft best practices:

http://technet.microsoft.com/en-us/library/cc966412.aspx
CERTIFIED EXPERT

Author

Commented:
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?
Armand GSenior Developer
CERTIFIED EXPERT

Commented:
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.
CERTIFIED EXPERT

Author

Commented:
Thank you, very informative.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.