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:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 3:02 PM To: [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 07.11.2002 19:47 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] 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.
