Unsolved
This post is more than 5 years old
1 Rookie
•
92 Posts
0
745
SQL-Traditional RGs, big metalun, or combo for all luns?
On our CX700 we just freed up 25 146g 10k FC drives and need to lay out SQL luns. How about 24 drives in 4x4 1/0 and carve luns for database, tempdb, and logs on these 24 drives? I think this may be a bad idea for tempdb and logs but I'm not sure and don't have time to benchmark before the weekend. Is it ok to have tempdb and logs on same spindles in a large meta? Or will this be better laid out with tempdb and log on totally separate disks for response time?
Loudenj
45 Posts
1
May 7th, 2009 18:00
You might like to read
EMC Clariion Database Storage Solutions: Microsoft Sql Server 2000, and 2005.
https://powerlink.emc.com/nsepn/webapps/btg548664833igtcuup4826/km/live1/en_US/Offering_Technical/White_Paper/H601_2CLARiiONStor_Arr_MS_SQLSvr_ldv.pdf
This helped us fine tuning the sql, not just on the array side of things. We did setup the tempdb on it's own RG (2 * 146gb FC 1/0). This gave a performance increase. Our developers have not been weaned of cusors so they where dumping a lot of user objects in the tempdb.Our MDF's are on a shared r5 RG, with the LDF's on a shared 1/0 RG.
hope this helps
John
RRR
2 Intern
2 Intern
•
5.7K Posts
0
May 8th, 2009 00:00
- How many IOps do you need ?
- How much space do you need ?