Re: dbspaces design in SAN arrays
Octavio Gomez wrote: > Hi everyone, > I used to work with servers with a bunch of disks connected to them, so > it was relative easy to design dbspaces and tables fragmentation in that > scene. > > Is there any special consideration for dbspaces, chunks and tables > fragmentation design in SAN environments with dozens or hundreds of > disks inside of one array? If you can, allocate different LUNs to each dbspace. Make sure you choose an appropriate LUN RAID level, i.e. no RAID5. Each LUN can be configured differently and moved around, so if you can keep to one dbspace per LUN and you run into performance or storage issues, you can get that LUN reconfigured. Use fragmentation as normal, even if you are not 100% sure about the physical location of your data, it's also about allocating more CPU resources. If you manage to saturate the SAN storage, then get your SAN Administrator to reconfigure that LUN. ;-) If you have enough invested in your SAN, you should also be able to play with business continuity volume (BCV) snapshots using external backups. Who doesn't like to see a several hundred Gb level 0 archive complete in a couple of seconds? :-D Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+
"Mark D. Stock" <mdstock@MydasSolutions.com> wrote in message news:mailman.134.1154639919.20706.informix-list@iiug.org... > If you can, allocate different LUNs to each dbspace. Make sure you choose > an appropriate LUN RAID level, i.e. no RAID5. Each LUN can be configured > differently and moved around, so if you can keep to one dbspace per LUN > and you run into performance or storage issues, you can get that LUN > reconfigured. ... > If you have enough invested in your SAN, you should also be able to play > with business continuity volume (BCV) snapshots using external backups. > Who doesn't like to see a several hundred Gb level 0 archive complete in a > couple of seconds? :-D If you're talking about BCVs this implies you're using EMC Symmetrix. If you have a Symmetrix you are *absolutely* wasting your time aligning LUNs and dbspaces, for the reasons I gave earlier. Is it only me who thinks this?! I keep reading people with expensive SANs advocating orthodoxies from the days when you were lucky if you had two disks (one of which was for the OS and swap anyway), and wonder if I'm missing something ...