Your Cache Hit pct is too low, needs to be closer to 99%.
I would increase bufpoolsize to 131072, that's 128K and will show
as 32,768 Buffer pool pages. That should get you close or there and
eliminate the Cache Wait Pct - normally that's zero!
Expiration will be most obvious speed improvement.
David Longo
>>> ldahl AT JPL.NASA DOT GOV 11/20/02 05:24PM >>>
Output from q db f=d:
Available Space (MB): 50,012
Assigned Capacity (MB): 45,012
Maximum Extension (MB): 5,000
Maximum Reduction (MB): 10,720
Page Size (bytes): 4,096
Total Usable Pages: 11,523,072
Used Pages: 7,574,343
Pct Util: 65.7
Max. Pct Util: 76.2
Physical Volumes: 51
Buffer Pool Pages: 10,500
Total Buffer Requests: 180,673,719
Cache Hit Pct.: 90.08
Cache Wait Pct.: 1.74
Backup in Progress?: Yes
Type of Backup In Progress: Full
Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 64.07
BufPoolSize 42000
I increased the bufpoolsize from 37000 to 42000 a few days ago to bring
the
ratio up? Will this affect performance on the system (swap usage or
paging)?
Yes, DB volumes are on Veritas filesystem... I can get you the exact
Veritas
levels if it would help...
Thank you very much, I really appreciate the help!
Zlatko Krastev/ACIT wrote:
> 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
"MMS <health-first.org>" made the following
annotations on 11/20/2002 07:22:02 PM
------------------------------------------------------------------------------
This message is for the named person's use only. It may contain confidential,
proprietary, or legally privileged information. No confidentiality or
privilege is waived or lost by any mistransmission. If you receive this
message in error, please immediately delete it and all copies of it from your
system, destroy any hard copies of it, and notify the sender. You must not,
directly or indirectly, use, disclose, distribute, print, or copy any part of
this message if you are not the intended recipient. Health First reserves the
right to monitor all e-mail communications through its networks. Any views or
opinions expressed in this message are solely those of the individual sender,
except (1) where the message states such views or opinions are on behalf of a
particular entity; and (2) the sender is authorized by the entity to give such
views or opinions.
==============================================================================
|
