ADSM-L

Re: Slow/serial database reads?

2006-10-17 10:33:10
Subject: Re: Slow/serial database reads?
From: Jason Lee <english AT ANIM.DREAMWORKS DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 17 Oct 2006 07:30:58 -0700
I actually upped the bufferpool to 2GB from 512MB to try to get
around this. My Cache hit rate was ~96% before putting it up. This is
a 4GB 64bit machine doing nothing else. There is free RAM, though not
as much as there was :-) Actually the dsmserv process is running at
about 2.3GB right now. 1.3GB cached (filesystem).

It would be beneficial to me if someone could show me an iostat or
some such that showed that I was in fact broken. Right now I'm
assuming that the TSM database is broken, but maybe it just sucks?

BTW - I notice when looking at show threads, all the
DIskServerThreads are using the same mutex... which suggests
serialization to me.


Any thoughts?


Thanks


Jason



On Oct 17, 2006, at 7:16 AM, Richard Sims wrote:

On Oct 17, 2006, at 9:49 AM, Sergio Fuentes wrote:

With bufferpool set too high, it actually chokes server performance.

Sergio -

A statement like that needs contextual clarification,
as for example whether the environment is 32-bit or 64-bit, and
whether the system has copious memory to devote to static allocation.
Certainly, in some contexts an oversized buffer pool size is known to
degrade performance, but a large size can certainly help, where the
overall architecture well supports it.

   Richard Sims



--
Jason Lee
DreamWorks Animation
(818) 695-3782

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