Unsolved
This post is more than 5 years old
14 Posts
0
2275
May 13th, 2009 17:00
DMX-4 Large meta-lun performance
Hi all,
We currently have a dmx-4 with 100 disks and 8gb hypers, the problem is some of the sql databases are 450-500gb in size. Therefore we are creating meta luns of 500-600gb in size.
The performance obviously goes to crap because of the contention for spindles, what is the best way to work around this problem? Ideally best performance would be around the 200gb meta-lun size. Has anyone else worked around this?
Thanks
Dave
We currently have a dmx-4 with 100 disks and 8gb hypers, the problem is some of the sql databases are 450-500gb in size. Therefore we are creating meta luns of 500-600gb in size.
The performance obviously goes to crap because of the contention for spindles, what is the best way to work around this problem? Ideally best performance would be around the 200gb meta-lun size. Has anyone else worked around this?
Thanks
Dave
No Events found!


Quincy561
1.3K Posts
1
May 13th, 2009 19:00
Are you running 5773? If not, that should be your first step. 5773 introduced a front-end aware prefetch that knows what a meta volume is. Previous releases of Enginuity did not have meta aware prefetch.
I would suggest making logical volumes that will satisfy your host volume size with 4 or 8 meta members if possible. Fewer members, and fewer logicals in the box generally gives better overall performance.
dave12341
14 Posts
0
May 13th, 2009 20:00
when you say logicals I assume you are referring to the hypers?
So can I use ECC to change some of the 8gb hypers to larger sizes?
Alok Jain,
Host based lvm had crossed my mind but i would like to keep it simplier. Which LVM software do you use at the host level?
alokjain1
44 Posts
0
May 13th, 2009 20:00
alokjain1
44 Posts
0
May 13th, 2009 20:00
Are these striped meta LUNs? One thing to keep in mind is that more LUNs at the host level (as opposed to 1 large meta LUN) provide higher number of LUN queues that improve the performance. So presenting higher number of LUNs to host and then using a volume manager to stripe at the host level will provide better performance (at least in my experience)
BTW, what is the measurement (which metric and at host or at the array) that is showing disk contention?
dave12341
14 Posts
0
May 13th, 2009 20:00
Yes I am running 5773.
the problem with using less members is the fact that our physical database is a specific size that needs to be minimum
Quincy561
1.3K Posts
1
May 13th, 2009 20:00
dave12341
14 Posts
0
May 13th, 2009 21:00
What you suggest would work for me, however I am reluctant to leave my data integrity up to windows.
Yes we are using 64k alignment.
The best approach for me I think is to change some of the unmapped 8gb hypers into 16 or 24gb hypers
alokjain1
44 Posts
0
May 13th, 2009 21:00
If single LUN at the host is the bottleneck, then having bigger hypers will not help. Check to make sure you are not hitting any target LUN queue depths because of single LUN. For databases it is advisable to have multiple LUNs to separate out the data/logs/indexs etc. You can try it out.
dave12341
14 Posts
0
May 13th, 2009 22:00
We are using seperate luns, logs,data and backup. The speed problem is because the dba's refuse to archive/split/reduce the size of databases, gradually larger and larger luns are required.
We have got to the point were the large luns are performing 5 times worse than the smaller luns attached to the same server. We know this from our benchmarking, but you guys have seen the same thing.
Increasing the hyper size sounds like it might be the workaround we need.
RRR
6 Operator
•
5.7K Posts
0
May 14th, 2009 01:00
Quincy56, I always check (symdev show) to see what the physical underlying spindels are and I make sure I'm not including a single spindel in the same META twice. In the Symm Performance Workshop my instructor Desirée T. agreed with this aproach and so far I haven't seen performance issues. I have RAID5 META's as large as 32 members, where the 32 members each consist of 4 spindels (3RAID5, so 4 spindels per symdev) and 32 x 4 = 128 spindels, which (coincidence ?) is exactly the range of spindels I'm creating symdevs on
I'm using my backend as good as possible, I think.
Quincy561
1.3K Posts
1
May 14th, 2009 03:00
Wrapping on disks with meta volumes is generally not a good idea. It can create unnecessary head seeks.
Larger numbers of meta members in meta volumes does not cause problems by itself, but it can be difficult to get enough IOs queued to such a device to keep it busy. Also fewer, larger hypers and logical volumes create better overall system performance.
RRR
6 Operator
•
5.7K Posts
0
May 14th, 2009 04:00
But indeed: a 16 way 7RAID5 = 16 x 8 = 128 disks and a 32 way 3RAID5 = 32 x 4 = 128 disks as well. And if these 128 disks are unique disks, there's no wrapping.
I also agree with you on the larger symdevs, but perhaps on another level: if I/O is sequential and your META has a limited number of members, the chance of getting true sequential I/O per member is higher than when you'd have a large number of members per META, since chances are higher that an alien I/O (of another host) gets inbetween your I/O's and the sequence is broken..... If you catch my drift
dave12341
14 Posts
0
May 31st, 2009 22:00
After having this discussion I have decided it will be best if we change a section of unmapped logical symdev's from 8gb to 24gb or 32gb logicals.
How would I go about this.
The unmapped dev's are all linear, and I plan on using the last half of the remaining unmapped 8gb logicals.
Obviously I will have to use the "delete logical device". However I am not sure the best practise for creating them via ecc or solutions enabler.
xe2sdc
6 Operator
•
2.8K Posts
0
June 1st, 2009 02:00
Don't hold your breath but keep an eye at messages