help with solaris x86 performance tuning (kernel parameters, /etc/systemsettings) - 06-23-2005 , 11:44 PM
I started working at a site with 2 progress databases (versions 8.1 and
8.3). I've worked with oracle databases on unix/linux before so I'm a
bit familiar with performance settings for databases on unix/linux machines.
These databases run VERY slow!!
a simple query on a small table takes a few minutes!!
I noticed the /etc/system file is pretty much bare (at default settings,
just a few notes but nothing set)
I've done a bit of reading and it looks like the /etc/system file has to
be modified with non-default settings to improve the database performance.
I've attached some outputs from promon (activity and stats).
The servers are proliant ml370 and dl380. the 370 is dual CPU (733MHZ)
and 512MB RAM. The dl380 is 800MHZ cpu (single) and 724MB RAM. Both
use scsi raid controllers (using RAID1 with online hot-spare). As you
can see, the database is not too big. during daytime, about 20-30 users
hit it. It's running an application called ICAS.
I started writing reports and this is how I've noticed the performance
stinks on these boxes. I'm guessing the memory available to progress
could be set higher. Is there also a setting for how much CPU to give
progress? I notice even when it's fully loaded, the CPU only gets to
Thank you so much for tips/pointers!
ps. I rebuilt the indexes on the dl380 after reading some of the docs.
I can't tell if this made a big difference, but I do know it doesn't
hurt to rebuild indexes (especially if they haven't been rebuilt in a
few years!) No unix/database person has worked on these boxes for a