Re: Brain Death

"Nuno Souto" <nsouto_at_nsw.bigpond.net.au.nospam> wrote in message news:3af94cf1.18847064_at_news-server...
> On Wed, 9 May 2001 14:53:50 +0100, "Niall Litchfield"
> <n-litchfield_at_audit-commission.gov.uk> wrote:
>
> >we run a 3rd party financials solution in a WAN environment.
> >
>
> Hmmm, suspiciously familiar...
>
>
> >Problem is that remote sites report a (very real) loss of performance in
> >OLTP work. However
> >
> >a) local sites do not report this problem, suggesting database tuning is
> >adequate and
> >b) also report.txt gives no undue waits,locks or bad hit ratios etc.
> >
>
> Yup, definitely VERY familiar.
>
> >Any suggestions as to where to look. especially is a file copy an
 adequate
> >test of network performance or is there more I could do? Ping and tracert
> >are OK.
>
> 10 to 1 says the code for this app is in DLLs that get loaded from a
> central file server or even worse, using the same line as the comms to
> DB. And what the users complain about is not real database activity
> time but time taken in getting screens to do anything (DLL load time).

Nope thats our other app! Except that the .dlls aren't .dlls at all but foxpro forms (don't ask!).

The configuration isn't that unreasonable and this is a new problem on an 18month old site. Thanks for the help though.

--
Niall Litchfield
Oracle DBA
Audit Commission UK