ADSM-L

Re: Fragmented Database Maybe?

2003-02-28 10:50:18
Subject: Re: Fragmented Database Maybe?
From: Richard Sims <rbs AT BU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 28 Feb 2003 10:49:35 -0500
>I'm Running TSM 4.2.2.12 on a Solaris 2.7 server (E250 400Mhz, 1GB mem).
>We have been having severe performance issues recently and moved our database
>volumes off onto a new disk...

You haven't cited the cause-effect case which would motivate such a change.
Are you certain that is the problem area?  If this is a substantial server,
then I would first wonder about the 1 GB memory size, which is rather small
these days.  More memory is usually the most expeditious way to increase
the performance of a computer system.  System performance monitoring should
reveal the bottlenecks.

>Also, is there anyway to see if indeed the database is fragmented?

(Chuckle)  By definition, all databases are "fragmented" - it's inevitable,
and the way they operate.  You will see numerous postings in the archives
that advise you not to be fixated on this, as it's unavoidable, and efforts
to "fix" it are ephemeral and time-costly.

  Richard Sims, BU

<Prev in Thread] Current Thread [Next in Thread>