Clicky

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.

asked 11/01/2011 11:33

ryan80's gravatar image

ryan80 ♦♦


4 Answers:
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
link

answered

armchang's gravatar image

armchang

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?
link

answered 2011-11-01 at 21:08:32

ryan80's gravatar image

ryan80

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

answered 2011-11-03 at 15:25:37

armchang's gravatar image

armchang

Thank you, very informative.
link

answered 2011-11-03 at 22:44:35

ryan80's gravatar image

ryan80

Your answer
[hide preview]

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

Asked: 11/01/2011 11:33

Seen: 245 times

Last updated: 11/04/2011 01:13