ADSM-L

Re: Best Database Performance

2001-11-12 05:23:11
Subject: Re: Best Database Performance
From: Salak Juraj <j.salak AT ASAMER DOT AT>
Date: Mon, 12 Nov 2001 11:05:45 +0100
Hi,

this has been discussed very often, you may ant to have a look into
forums history on http://msgs.adsm.org.

Database performace is all about random access times, not about speed of
streaming.

Basically, TSM will start one I/O in each database volume,
so having 4 database volumes spread over 4 physical disk may be a good
solutions.

If your disk controller has sigificant amount of cache and good
optimising alghoritm,
enabling much more I/O on one disk could be helpfull. If you have almost
no cache on controller and on your disks,
this may slow down your DB significantly.

There are few parameters in OPT file which affect the performance
(parallel write, read with verify),
there you can gain some speed at the costs of security.

Do allow as much  software disk cache as possible, it usually helps a
lot.

Berst Regards

Juraj ?alak
Asamer Familienholding G M B H
EDV
Unterthalhamstraße 2
A-4694 Ohlsdorf
Österreich
www.asamer.at

Büro: +43 7612 799 529
Mobil: +43 664 528 6474
e-mail: j.salak AT asamer DOT at







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