ADSM-L

Re: Poor database performance

2003-04-01 10:19:13
Subject: Re: Poor database performance
From: Remco Post <r.post AT SARA DOT NL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 1 Apr 2003 17:18:41 +0200
On Tue, 1 Apr 2003 08:46:56 -0600
Tab Trepagnier <Tab.Trepagnier AT LAITRAM DOT COM> 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 into "a few" volumes?  Or
> should I look elsewhere?
>

In my experience, and that is supported by logic, spreading a TSM database
acros a large number of phisical volumes increases the database throughput.
Separating the db volumes from the log volumes halps yet another bit. In
short: more disks is better. We currently have out db split across 4 volumes
(each a hardware raid1) and a seperate volume for the log, and are quite
pleased with the performance.

--
Met vriendelijke groeten,

Remco Post

SARA - Stichting Academisch Rekencentrum Amsterdam    http://www.sara.nl
High Performance Computing  Tel. +31 20 592 8008    Fax. +31 20 668 3167

"I really didn't foresee the Internet. But then, neither did the computer
industry. Not that that tells us very much of course - the computer industry
didn't even foresee that the century was going to end." -- Douglas Adams

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