From: Jonathan Williams (jonathw@shubertorg.com)
Date: Fri Aug 16 2002 - 10:20:41 EDT
Hi...
First question is about tuning a DB server:
my manager wanted me to send in a question...so don't blame me if it doesn't
make much sense. We have a database server (ES40 running 5.1 pk 3), and my boss
wants to know about allocating memory. That's the words he used, but I think
he's more interested in tuning the system for optimal database performance. Are
there any recommended settings or what-not for a typical database server? This
server runs absolutely nothing else except for this one database. It currently
seems to use about 1/2 GB of memory, but there are 4 gigs in there. Is there a
way to make it use even more memory so the DB runs better? We are not
experiencing any problems with performance, but I think he just wants to make
sure we are running as fast as we can. Any info or anything to bring to him
would be greatly appreciated.
The second question is even more annoying. About a year ago I was told to send
out an email and find out what tools people are using to monitor system
performance (system level as well as application level). I got a bunch of
emails suggesting things like: collect, monitor, DCPI, BMC, etc. I took all
those emails gave them to my boss, and he promptly did nothing with them. Now,
a year later he asks the same question. So basically I'm wondering once again
what people use to monitor system and application performance (including memory
usage, disk usage, disk I/O statistics, etc). All of our systems are ES40's
running 5.1 pk 3, except for one ES45 running 5.1a.
I'm sorry both of these questions are vague and general, but any information on
either question would be greatly appreciated.
Jonathan Williams
Unix Systems Administrator
The Shubert Organization, Inc.
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:48:49 EDT