Re: Brain Death

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Wed, 09 May 2001 14:07:23 GMT
Message-ID: <3af94cf1.18847064@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).

>
>any suggestions that this problem has chosen to rear its ugly head after I
>went down the pub are entirely justified.
>

Now, why can't I do this? :-D

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Wed May 09 2001 - 09:07:23 CDT