HP3000-L Archives

October 2000, Week 1

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Wirt Atmar <[log in to unmask]>
Reply To:
Date:
Wed, 4 Oct 2000 13:16:56 EDT
Content-Type:
text/plain
Parts/Attachments:
text/plain (35 lines)
While Kim suggested hairballs as the cause of Connie's problems:

> From time to time over the last few weeks, my 937 has been experiencing
>  periods of extremely slow response.  We're running about 22 sessions, 1
>  job, with 192 MB memory (additional memory has been ordered). 9.6 GB total
>  disk, less than 55% full.   Other than some DB capacity increases lately,
>  nothing (to my knowledge) has been changed from a month ago, when it was
>  fine.
>
>  I've checked TurboImage dataset capacities - at first it seemed to go slow
>  during DDX - disabled that; still have a problem.  No one is doing serial
>  reads in QUERYNM, or other programs.  Response time may be as long as 10
>  seconds.  Then after 10 minutes or so of this, it speeds back up and is OK
>  for a few hours.
>
>  We don't have HP Glance or other performance tools, and I'm waiting on HP
>  response center for feedback - any ideas?
>
>  Thanks to all who may offer a suggestion.

...I would tend to think that you may (and *may* is only a maybe) answered
your question in your first paragraph: recent DB increases. There's nothing
that will cause apparent overall system degradation better than heavy
synonyming in one or more master dataset.

If you have Adager or other similar tools, use them to look around and see
what you can find. If this is the problem, the solution is quite
straightforward: resize your master datasets so as to absolutely minimize
synonyms (and especially migrating secondaries).

Again, this is only a "maybe", and it has to be taken in that light, but it
is a common cause of the symptoms you're reporting.

Wirt Atmar

ATOM RSS1 RSS2