ADSM-L

Re: Database Questions

2002-11-20 15:28:03
Subject: Re: Database Questions
From: "Remeta, Mark" <MRemeta AT SELIGMANDATA DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 20 Nov 2002 15:26:53 -0500
I have a 40gb database on RAID5 with no performance issues.. fyi...
not sure if you consider this small, average, or heavy.


-----Original Message-----
From: Zlatko Krastev/ACIT [mailto:acit AT ATTGLOBAL DOT NET]
Sent: Wednesday, November 20, 2002 3:02 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Database Questions


You can find long discussions on this topic in the list archives.
- it is mostly disadvantageous to have more than one or two DB volumes per
disk/array - parallelism you create with more volumes results disk heads
moving back and forth. You are shooting yourself in the leg.
- RAID 5 is definitely not very good for TSM DB and for average or
heavy-loaded server might be disastrous for performance. For small servers
might be just fine. Your server with 35 GB DB does not fit in second
category.
- "sessions running for hours" sounds terrible. What is DB cache hit
ratio? Do you have DB volumes on Veritas filesystem?!?

Zlatko Krastev
IT Consultant






Luke Dahl <ldahl AT JPL.NASA DOT GOV>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
07.11.2002 19:47
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Database Questions


Does anyone know of any advantage/disadvantage of the file sizes for the
database?  Is there an advantage to creating many 1Gb .db files over
fewer 10Gb .db files?  Also, we're running TSM 4.2.1.15 on Solaris 5.8
using raid 5.  I've heard performance can be much greater with raid 0.
Any truth to that?  We're seeing load averages above 10 nearly every day
and TSM performance is pretty poor.  Our database size is 35Gb and
sessions are running for hours (even small incrementals of various
workstations).  Network bandwidth hasn't peaked over 50% in any 24 hour
duration.  Any thoughts?  Many thanks in advance.

Luke Dahl
NASA - Jet Propulsion Laboratory
818-354-7117

Confidentiality Note: The information transmitted is intended only for the
person or entity to whom or which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of this information by persons or entities other
than the intended recipient is prohibited. If you receive this in error,
please delete this material immediately.

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