Optimum Raid Config For SQL Server 2005 On CX4-120
Hi
What is the optimum Raid and Lun lay out config for my CX4 120 .I have two DAE with 146 Gb Fully loaded .I have Database and tempDb And logs.
What iam planning to do is to put my tempdb and logs on riad 1+0 rg on seperate luns .And my db on other 1+0 rg .also iam using mirroveiw /s to make a mirror on other CX4 120(on the DR site) of the same config .From the mirror iam making a clone and using it for report genration.could you guys sujjest me the best config for perfomance.
bjpower
15 Posts
421
1
Posted August 8th, 2010 03:00
The main thing we need to know for each lun is
1. the expected IO/s
2. the data pattern expected - sequential or random.