<div>
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?
</div>


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?

<div>
It's for the volume alignment of your disk and yes, you can define it but you need to be careful.<br />
<br />
You can use SQLIO/ Windows System Monitor tool &nbsp;for the testing &nbsp;average read size of disks on your first question.
</div>


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.

<div>
Thank you, very informative.
</div>


<div>
<div class="content wysiwyg-content">
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.
</div>
</div>


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.

Finding average read size for a server.

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

Computer data storage, often called storage or memory, is a technology consisting of computer components and recording media used to retain digital data. In addition to local storage devices like CD and DVD readers, hard drives and flash drives, solid state drives can hold enormous amounts of data in a very small device. Cloud services and other new forms of remote storage also add to the capacity of devices and their ability to access more data without building additional data storage into a device.