From: Jonathan Williams (jonathw@shubertorg.com)
Date: Fri Aug 16 2002 - 11:58:03 EDT
Ok...I guess it would help if I mentioned that we are using Informix (don't
laugh...bah, ok you can laugh) Dynamic Server 9.30FC1X6.
The database is currently only using about 75 GB of disk space (with 144
allocated--it's growing rather quickly).
We use Xipc middleware (once again, don't laugh too hard).
The main database server only runs one database, but other servers have 4 or 5
databases running on them (each with a separate Informix Instance).
Hope that answers some peoples questions. I've gotten a ton of responses so
far, keep 'em coming. =)
Jonathan Williams
Unix Systems Administrator
The Shubert Organization, Inc.
----- Original Message -----
From: "Jonathan Williams" <jonathw@shubertorg.com>
To: <tru64-unix-managers@ornl.gov>
Sent: Friday, August 16, 2002 10:20 AM
Subject: 2 questions in one
> 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