Re: Latch free waits..

Norman Dunbar <Norman_at_DELETE_THIS.BountifulSolutions.co.uk> wrote in message news:<MPG.1b73335a558533bf989681_at_news.demon.co.uk>...
> In article <xBMNc.20376$K53.3804_at_news-server.bigpond.net.au>,
> richard.foote_at_bigpond.nospam.com says...
> > Actually Ron, using statspack to determine performance issues for these
> > types of scenarios is entirely the *wrong* thing to do.
> >
> <SNIP>
> > A far better "start point" for the OP to take would be to trace just those
> > sessions that are "slowing down" with a level 12 10046 event and see
> > *exactly* what is causing the slow down. No summarisations, no taking all
> > the other transactions data into the mix, no guessing and hoping you might
> > stumble on the real issue(s), but *know for sure exactly* what the
> > associated waits and resources are that are causing the slow down. Once you
> > know what the issues are, what's most affecting the response times, then
>
> Hi Richard,
>
> looks like I've read that book too - I like 'Method R'.
>
> The problem is, what happens if the OP is running MTS - it's a hell of a
> jigsaw effort to find all the trace files and stich them together in the
> right order - I know, I've had to do it :o(
>
> How's life in general then - still listening to 'The Laughing Gnome' ? I
> believe that there's a new verion coming out soon - 'The Laughing
> KDE' :o)

LOL! We'll have to make a linux distro named Detroit just so we can Panic it...

>
> Sorry, couldn't resist !

mumblemumble Thin White Duke mumblemumble Tin Machine mumblemumble Tin Man mumblemumble If I Only Had a Heart Attack mumblemumble Dead Man Walking mumblemumble Here Today, Gone Tomorrow mumblemumble We Are The Dead mumblemumble

jg

--
@home.com is bogus.
"not at the London school of eco-gnome-ics"