From: Jonathan Williams (jonathw@shubertorg.com)
Date: Fri Aug 16 2002 - 12:32:12 EDT
Bah...Ok...apparently the boss has been withholding information from me. We
have a server running just one single Informix database. We have some informix
tool that is telling us that the informix database is only using 512MB of memory
(out of the 4 gigs). Our Informix DBA (if you can call him that) swears he has
the database setup properly in that it SHOULD be using as much memory as it
wants (it is set to "unlimited"). So I guess basically the question is, why is
it only using 1/8 of the available memory. Also there is 93% swap space
available. To me this sounds more like an informix question, but of course
everyone is blaming the OS. Why the Informix DBA isn't talking to Informix
about this is beyond me. Anyway, TIA
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 11:58 AM
Subject: UPDATE: 2 questions in one
> 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