Re: San Performace with SQl Server
- From: "victor.engle@xxxxxxxxx" <victor.engle@xxxxxxxxx>
- Date: 26 Aug 2005 06:16:10 -0700
Saradhi,
The problem is most likely read cache as you suspect. The cx500 is a
midrange array and has limitations with regards to cache and i.o paths.
You can probably improve i/o performance for random reads by using
mirrored raid groups rather than raid-5. 2D+2D is probably what you
want for performance sensitive requirements including your logs.
Regarding smaller luns, you probably can get more performance with them
if you're carefull about how you assign the luns to the host. For
example you would get good performance if you have 5 2d+2d raidgroups
and you create a 36G lun from each and assign them to your host then
stripe the luns on the host side. In that configuration you would have
20 spindles powering your volume. If that methodology is followed for
all storage allocations you would maximize your array's performance and
reduce hot spots etc.
I don't think I would change your cache configuration. If you use any
raid-5 then you really need to keep all that write cache.
Regards,
Vic Engle
.
- Follow-Ups:
- Re: San Performace with SQl Server
- From: saradhi
- Re: San Performace with SQl Server
- References:
- San Performace with SQl Server
- From: saradhi
- San Performace with SQl Server
- Prev by Date: Snap! Assist Software
- Next by Date: Re: General musings and/or recommendations on number of global spares to keep?
- Previous by thread: San Performace with SQl Server
- Next by thread: Re: San Performace with SQl Server
- Index(es):
Relevant Pages
|
