Re: Informix Database and Performance

From: Bryan Manthei <bryan@musicland.com> > >What are people doing for optimizing the layouts of their Informix >Database instances. >How have people addressed factors as disk layouts, Shared Memorey and >Table Layouts? > >We are currently in an effort to try and optimize our Informix instance >given the current hardware we are useing. > >AIX 4.3.2 >IBM RS6000 - S70 8-way binding 7 processors to DB 5Gb memory. >Disk - SSA D-40, 4 and 9Gb disks. We have 19 disks to play with over 15 >Logical Volumes to >be used by Informix. > >What works the best, small pools of disk with data over multiple disks >for r/w heads, isolating logical volumes to individual disks, one big >pool of disks with data spead over all disks? I like to have complete control (small pools), but if you have a lot of disk, it's probably better to use one big pool. (Easier, allegedly). Don't use RAID 5. >How about shared memory usage, what works best here? I think AIX is limited to 10 SHM segments, so make your shmvirtsize quite big. Unfortunately AIX doesn't support residency. >I am monitoring disk and system performance on the unix side with >commands like, vmstat, iostat, monitor, what else is there? How can we >get to the table level and monitor more on the DB side? What are the >best monitoring tools? BMC patrol seems quite popular. Platinum DB/Vision I don't know. EcoTools from Compuware looks quite nice, and goes well with their network monitoring tools (Econet) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com