Unsolved
This post is more than 5 years old
57 Posts
0
728
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.
My Db size is 100gb now
Tempdb 20 gb
Logs 10 Gb
Sql 2005 windows 2008
Thanks In Advance
bjpower
15 Posts
1
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.
adin2
57 Posts
0
August 8th, 2010 06:00
The expected i/o i have to check but consider it for a typical sql server
But the data acsess pattern is random
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
0
August 9th, 2010 02:00
If your DB consists of more reads and less writes perfer Raid 5. Because Radi 5 performs better in these 2 conditions.
Highest Read data transaction rate
Medium Write data transaction rate
As your Temdb & Logs will have more wirtes let it configure with Raid 10.
kelleg
4.5K Posts
1
August 9th, 2010 08:00
Don't forget to check the Best Practice guides for CLARiiON - the most important are located in the Documents section of this forum:
EMC CLARiiON Performance and Availability Release 29.0 Firmware Update Applied Best Practices.pdf
EMC CLARiiON Storage System Fundamentals for Performance and Availability
White Paper: An Introduction to EMC CLARiiON Storage Device Technology — Applied Technology
glen