Welcome to the forums peldon I've moved your question from the Powerlink Lite forum into the CLARiiON forum where it belongs. And yes dynamox peldon should be able to access everything on Powerlink.
Sorry for the late reply, but have you considered taking a performance workshop ? I've had these on Clariion as well as Symm and those are goooood
If your db isn't hit too hard by read req's, you could consider RAID5 for the db and RAID1 or 10 for the logs. If your db is being hit very hard, you could consider RAID10 for everything. Do the math on needed IOps and the IOps the disks in a RAID Group can provide. Take the write penalty into account as well (RAID1/10 has a WP of 2, R5 has 4 and R6 has a WP of 6). what's your R/W ratio ? How many IOps does your app generate ? Stuff like that.
1) how many IOps does the app generate ? 2) what's the Read/write ratio ? 3) so how many IOps does your array need to handle ? 4) do the math for 10k, 15k, RAID10, RAID5 5) how much space do you need ? 6) is it cheaper to buy lots of small disks of a few large disks ? 7) what are the prices when you use 10k disks and what if you were using 15k drives ? 8) compare all the solutions and decide which way to go
One great advantage of having a Clariion is that you can (for example) start on RAID5 for db and RAID1 for the logs and see if it's ok. If not, you can migrate the db to RAID10 or a larger Raid Group. You can migrate your LUN around....
You need free disks to work with though
It's better to calculate what you really need.
Example: an SQL server generates 1000 IOps, read/write ratio is 75/25 750 reads 250 writes per second on RAID10 this is: 750 + 2x250 = 1250 IOps on RAID5 this is: 750 + 4x250 = 1750 IOps on RAID6 this is: 750 + 6x250 = 2250 IOps
the 10k math is: RAID10: 1250 / 140 = 8.9 disks, so 10 disks (5+5, always even number) RAID5: 1750/140 = 12.5 disks, could be 13 disks (12+1), 2x7 (6+1) or 3x5 (4+1) depending on your standards RAID6: 2250 / 140 = 16.1 disks, could be 2x9 (7+2), 3x6 (4+2) the 15k math is: RAID10: 1250/180 = 6.95 disks, so 8 disks (4+4) RAID5: 1750/180 = 9.72 disks, 2x5 (4+1) or 10 (9+1) RAID6: 2250/180 = 12.5 disks, 2x7 (5+2)
Do the calculated raid groups provide enough space for your app ? What does each raid group set up cost ?
For db's, don't go to SATA or RAID6, use logs on RAID1 or RAID10. MetaLUN's are good for performance, so if you need 13 disks in RAID5, 1 big striped MetaLUN on 2 7RAID5's is ok.
Don't use the free space in your Raid Groups, because those will generate additional I/O's which will degrade the values available for your app ! So better go for small disks instead of "cheaper" large ones, unless you really need the space for this one app server.
dynamox
9 Legend
•
20.4K Posts
0
February 17th, 2009 04:00
do you have access to browse PowerLink white papers section ?
julieg1
2 Intern
•
305 Posts
0
February 17th, 2009 13:00
I've moved your question from the Powerlink Lite forum into the CLARiiON forum where it belongs.
And yes dynamox peldon should be able to access everything on Powerlink.
Julie
Forums Admin
RRR
4 Operator
•
5.7K Posts
0
February 18th, 2009 02:00
peldon
2 Posts
0
February 18th, 2009 13:00
Thanks for input. Yes I'm looking for how to configure for performance, and I still cannot find this.
Thanks
-peldon
RRR
4 Operator
•
5.7K Posts
0
April 20th, 2009 04:00
If your db isn't hit too hard by read req's, you could consider RAID5 for the db and RAID1 or 10 for the logs. If your db is being hit very hard, you could consider RAID10 for everything. Do the math on needed IOps and the IOps the disks in a RAID Group can provide. Take the write penalty into account as well (RAID1/10 has a WP of 2, R5 has 4 and R6 has a WP of 6). what's your R/W ratio ? How many IOps does your app generate ? Stuff like that.
1) how many IOps does the app generate ?
2) what's the Read/write ratio ?
3) so how many IOps does your array need to handle ?
4) do the math for 10k, 15k, RAID10, RAID5
5) how much space do you need ?
6) is it cheaper to buy lots of small disks of a few large disks ?
7) what are the prices when you use 10k disks and what if you were using 15k drives ?
8) compare all the solutions and decide which way to go
RRR
4 Operator
•
5.7K Posts
0
April 20th, 2009 05:00
You need free disks to work with though
It's better to calculate what you really need.
Example:
an SQL server generates 1000 IOps, read/write ratio is 75/25
750 reads 250 writes per second
on RAID10 this is: 750 + 2x250 = 1250 IOps
on RAID5 this is: 750 + 4x250 = 1750 IOps
on RAID6 this is: 750 + 6x250 = 2250 IOps
the 10k math is:
RAID10: 1250 / 140 = 8.9 disks, so 10 disks (5+5, always even number)
RAID5: 1750/140 = 12.5 disks, could be 13 disks (12+1), 2x7 (6+1) or 3x5 (4+1) depending on your standards
RAID6: 2250 / 140 = 16.1 disks, could be 2x9 (7+2), 3x6 (4+2)
the 15k math is:
RAID10: 1250/180 = 6.95 disks, so 8 disks (4+4)
RAID5: 1750/180 = 9.72 disks, 2x5 (4+1) or 10 (9+1)
RAID6: 2250/180 = 12.5 disks, 2x7 (5+2)
Do the calculated raid groups provide enough space for your app ?
What does each raid group set up cost ?
For db's, don't go to SATA or RAID6, use logs on RAID1 or RAID10. MetaLUN's are good for performance, so if you need 13 disks in RAID5, 1 big striped MetaLUN on 2 7RAID5's is ok.
Don't use the free space in your Raid Groups, because those will generate additional I/O's which will degrade the values available for your app ! So better go for small disks instead of "cheaper" large ones, unless you really need the space for this one app server.
kelleg
4 Operator
•
4.5K Posts
0
April 21st, 2009 09:00
EMC CLARiiON Performance and Availability Release 28.5 Firmware Update Applied Best Practices.pdf
http://powerlink.emc.com/km/live1/en_US/Offering_Technical/White_Paper/h5773-clariion-perf-availability-release-28-firmware-wp.pdf
White Paper: An Introduction to EMC CLARiiON Storage Device Technology ¿ Applied Technology
http://powerlink.emc.com/km/live1/en_US/Offering_Technical/White_Paper/H4208-an-intro-emc-clariion-hard0drive-tech-wp.pdf
EMC CLARiiON Fibre Channel Storage Fundamentals - Technology Concepts and Business Considerations
http://powerlink.emc.com/km/live1/en_US/Offering_Technical/White_Paper/H1049_emc_clariion_fibre_channel_storage_fundamentals_ldv.pdf
There are also a number of Best Practices White papers on PowerLink about SQL - do a search on White Paper SQL.
glen
AranH1
2.2K Posts
0
April 21st, 2009 12:00
White Paper: EMC CLARiiON Database Storage Solutions: Microsoft SQL Server 2000 and 2005 - Best Practices Planning
https://powerlink.emc.com/nsepn/webapps/btg548664833igtcuup4826/km/live1/en_US/Offering_Technical/White_Paper/H601_2CLARiiONStor_Arr_MS_SQLSvr_ldv.pdf?mtcs=ZXZlbnRUeXBlPUttQ2xpY2tDb250ZW50RXZlbnQsZG9jdW1lbnRJZD0wOTAxNDA2NjgwMzc0ZDVlLGRvY3VtZW50VHlwZT1wZGYsbmF2ZU5vZGU9MGIwMTQwNjY4MDFhNmI3ZF9Hcmlk
Reference Architecture: EMC Solutions for Microsoft SQL Server 2008 for Tiered Storage Enabled by EMC CLARiiON CX4 Series on iSCSI and Windows 2008
https://powerlink.emc.com/nsepn/webapps/btg548664833igtcuup4826/km/live1/en_US/Offering_Basics/White_Paper/h6016-emc-sol-ms-sql-svr-08-clariion-cx4-iscsi-ref-arch.pdf?mtcs=ZXZlbnRUeXBlPUttQ2xpY2tTZWFyY2hSZXN1bHRzRXZlbnQsZG9jdW1lbnRJZD0wOTAxNDA2NjgwM2RlOWE1LGRhdGFTb3VyY2U9RENUTV9lbl9VU18w
RRR
4 Operator
•
5.7K Posts
0
April 22nd, 2009 03:00