From: Jonathan Williams (jonathw@shubertorg.com)
Date: Fri Aug 16 2002 - 15:45:29 EDT
Ok...many many many emails later, I have begun looking into Big Brother for our
system monitoring tool (www.bb4.com). It has many many advocates (none more
devout than Jim Fitzmaurice, who has been invaluable in my pursuits). As far as
other monitoring tools, the usual selection came up: collect, monitor, top,
BMC, ehealth, etc etc.
big brother seems to be able to do most everything we need, and it's free to try
(and free to keep for non-commercial use).
I still have to sift through the ton of DB/system tuning messages I received.
I'll be posting a summary of this question when I figure out the answer
(hopefully won't take too long).
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 12:32 PM
Subject: UPDATE2: 2 questions in one
> 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