ADSM-L

Re: Database Questions

2002-11-21 10:39:41
Subject: Re: Database Questions
From: "Remeta, Mark" <MRemeta AT SELIGMANDATA DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 21 Nov 2002 10:37:39 -0500
it's not Solaris, Windows 2000 Advanced Server and I have 20 2gb volumes
defined.


Mark


-----Original Message-----
From: Luke Dahl [mailto:ldahl AT JPL.NASA DOT GOV]
Sent: Wednesday, November 20, 2002 5:18 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Database Questions


Solaris?  Which server version?  How many database volumes are there defined
to
TSM?  How big are your database volumes?  Thanks!

Luke

"Remeta, Mark" wrote:

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

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>