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
|
|
|