Re: ??? Opinions on ONCOFIG settings

Barry Leb wrote: > > We are not currently having any performance problems, but I am > interested in hearing some opinions from the experts out here. > > One of our systems is as follows: > > Sun SPARCcenter 2000E, Solaris 2.6, Veritas VM2.4 > 6 SPARCstorage Arrays 100's populated with 1gig and 4 gig drives > All data and indexes are spread across 158 1 gig drives. > 512 meg memory, 10 cpu's > Informix 7.14.ud5, Informix mirroring > > The system is 98% DSS. 99% of all inserts, updates and deletes done > through batch jobs approximately 2/3's of them run during off hours. > Largest table is 60 million rows of history. Next largest table only > 5.6 million rows. Tables are fragmented primarily by round robin with > largest tables spanning 8 dbspaces. All indexes on largest tables are > detached and fragmented by expression across as many as 10 dbspaces. > > Currently we have approximately 80 users with access to the database, > but typically we have at most 15 queries running at any given time. > Occasionally we may get as many as 25 queries peak. > > These are some of our onconfig settings: > > SHMVIRTSIZE 170000 > SHMADD 30416 > SHMTOTAL 0> PDQPRIORITY 2 Resources for every user qith DSS PDQPRIORTY = 100 / NUM. USERS > MAX_PDQPRIORITY 100 All your machine resources for DSS and nothings for OLTP ??? > DS_MAX_QUERIES 20 > DS_TOTAL_MEMORY 160000 > DS_MAX_SCANS 100> > PSORT_NPROCS is not set. > > 1. Given everything above, how would you configure these parameters? > 2. In the near future, DSS queries is likely to double or triple, > would you set the parameters differently? > > I am particularly interested in your opionions relating to decision > support variables and the best way to set PSORT_NPROCS variable. > > Thanks in advance. > > Barry Leb > > National Linen Service > 1420 Peachtree Street > MS #314 > Atlanta, GA 30309 > > (404) 853-6119 > (404) 853-6485 fax > e-mail: barryleb@mindspring.com -- Un saludo civil http://www.arraksi.es/~ramp