Re: Poor database performance - update

2003-04-01 Thread Remco Post
On Tue, 1 Apr 2003 16:04:19 -0500 David Longo <[EMAIL PROTECTED]> wrote: > Which brings up another general question I have been > thinking about posing for some time. > > With TSM the basic disk tuning theory, in a sentence, > for some years has been "spread DB, LOG and Disk Pool > out over as man

Re: Poor database performance - update

2003-04-01 Thread Richard Sims
>With TSM the basic disk tuning theory, in a sentence, >66or some years has been "spread DB, LOG and Disk Pool >out over as many separate disks/spindles as possible". > >Well as we are now getting 73 and 144GB disks, >and who knows what's next, then how are we TSM >Admins supposed to do that? Buy

Re: Poor database performance - update

2003-04-01 Thread David Longo
M Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:Re: Poor database performance Spreading the I/O among several disks is preferred as it increase the throughput. As RAID 0,1 is prefered to R

Re: Poor database performance - update

2003-04-01 Thread Tab Trepagnier
[EMAIL PROTECTED] cc: Subject:Re: Poor database performance Spreading the I/O among several disks is preferred as it increase the throughput. As RAID 0,1 is prefered to RAID 5 as each write is faster. Th

Re: Poor database performance

2003-04-01 Thread William SO Ng
| |

Re: Poor database performance

2003-04-01 Thread David Longo
You didn't mention what kind of disk (or array) you have? David Longo David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockledge, FL 32955-4305 PH 321.434.5536 Pager 321.634.8230 Fax:321.434.5509 [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 04/01/03 09:51 AM >>> I jus

Re: Poor database performance

2003-04-01 Thread Remco Post
On Tue, 1 Apr 2003 08:46:56 -0600 Tab Trepagnier <[EMAIL PROTECTED]> wrote: > When I built the new server, I took advantage of info on this forum and > created a single large DB volume on each DB disk. The DB is currently > laid out this way: > > ==> So what should I do? Split the database int

Re: Poor database performance

2003-04-01 Thread Hart, Charles
PROTECTED] Sent: Tuesday, April 01, 2003 8:47 AM To: [EMAIL PROTECTED] Subject: Poor database performance I just migrated our TSM system to a new pSeries 6H1 from our old F50. While I/O throughput is much higher, the database performance is surprisingly poor. I am asking for help in trying to

Poor database performance

2003-04-01 Thread Tab Trepagnier
I just migrated our TSM system to a new pSeries 6H1 from our old F50. While I/O throughput is much higher, the database performance is surprisingly poor. I am asking for help in trying to figure out why and what I can do about it. TSM 4.1.5.0 running on AIX 4.3.3 ML 10 6H1 2-way 600 MHz 64-bit 4