Have you run Robelle's HOWMESSY or the Contributed Software Library's
DBLOADNG reports against the database?

Also, are you running any performance monitor, such as <plug> SOS? <end
plug>



Craig M. Lalley

Systems Performance Specialist

Lund Performance Solutions

Phone (630) 717-8534 | Email [log in to unmask]

Fax (425) 920-4995| Web www.lund.com

NOTICE: This communication may contain privileged or other confidential
information. If you are not the intended recipient or believe that you
may have received this communication in error, please reply to the
sender indicating that fact and delete the copy you received. In
addition, you should not print, copy, retransmit, disseminate, or
otherwise use the information. Thank you.


-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of johnnymac
Sent: Wednesday, February 06, 2002 2:48 PM
To: [log in to unmask]
Subject: [HP3000-L] hp3000 with image/sql

we have an image database that's serving so slowly. This problem
seemed to start "out of no where" one day. we've tried using query,
and odbc sql to get data, and either way the database just responds so
slowly. This problem has even survived a reboot  :(

anyone have ideas on where to look? None of the tables are even close
to full, and the pid that seems to be locking the box is a system
process. any help would be much appreciated.

john mcfarlane

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *