DISKS IOPS

[#1]

A customer is asking for a number for the IOPS (Input/Output Operations Per Second)

I know that this is related to the RAID type (RAID5) but they are still asking for a number.

Is there anybody that can give my the required value for the IOPS?

They are working with SAN if this can help....

Thanks in advance,

Sam

[sorin_radulescu]

So actually we are going to speak about best practices for Microsoft SQL server.

You need one disk for data, one disk for transaction log and I suggest to have tempdb into separate disk.

If you really need detailed information then open Microsoft site and check into sql server site the best practices document.

Regards

Sorin Radulescu

[Former Member]

Sorin,

Thanks a lot for your reply.

Now they are just asking on how many disks this RAID types are calculated.

For example, if there are a lot of operations on the DB server, if they need more than one

disk to increase the write performance.

Could you help on this? Then they have their asnwer...

Thanks a lot for your help.

Kind regards,

Sam

[sorin_radulescu]

Into sizing document and also into performance tunning document from wiki is saying that

minimum recommended is app, web server has to be RAID1, db server RAID 5.

Recommendation is to use for OS RAID 1 and for data RAID 10.

Regards

Sorin Radulescu