ADSM-L

Re: Serious performance problems with large BUFPOOLSIZE

2006-01-27 13:28:42
Subject: Re: Serious performance problems with large BUFPOOLSIZE
From: Matthew Glanville <matthew.glanville AT KODAK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 27 Jan 2006 13:28:23 -0500
> I think the discussion could use more details about the architecture
> being used.
> If you haven't already, see IBM Technote 1208540.
>
>     Richard Sims

Ahh those details.....

TSM server 5.3.2 on Solaris 9, 64 bit, 8 cpus' 32 GB ram.
DB size, 150 GB, 75% used

Current BUFPOOLSIZE 1 GB

My testing revealed much slower performance for large multi file backups
(1 million + files per file system) with BUFPOOLSIZE's 4 GB, 16 GB, 30 GB,
with the latter being the worst.  18 hour incrementals at the 30 GB size,
went down to <3 hours at 1 Gb.

I believe the advice in the technote, of max 2 GB on 32bit systems, and
1/2 total system memory on 64bit sytems (which is why I ran into the
problem in the first place) is probablby not good advice, especially on
servers with large amounts of memory and large databases.

I'm sure more plays out in this problem, like database fragmentation,
memory speeds.

It doesn't make much sense does it that using more memory for a datbase
buffer slows the database reads down.
I'm sure someone else out there on this list has ther BUFPOOLSIZE set to
those larger sizes and is having this issue without even realizing it, as
I did.

Matt G.