Hi,
I know next to nothing about administering Online, and my users are
complaining about the database being slow sometimes.
Could some kind soul outline the simplest method for indicating
whether putting an extra processor and/or extra memory would solve the
bottleneck? I have tried using
onstat -g gloas stated in the manual but the output means nothing to me.
The OS is currently using less swap space than it has RAM, so I don't
imagine that it needs more memory, and forking out 5 grand for an
extra processor is quite a lot if it doesn't make a bit of
difference!!
I have read about binding online to use an extra CPU exclusively -
does anyone know if this is possible with Solaris 2.5, and if so, does
it work? Does it improve performance significantly?
I expect that the biggest performance gains would arise from correct
structuring of the database, indexes etc - I unfortunately don't have
any input on that side of things - I am just the lowly sysadmin and
it's my fault that it is running slowly!
I am running Online 7.1 under Solaris 2.5 on a SS20 with 64Mb RAM and
processor.
Thanks in advance,
Richard Hewitt