Re: Performance puzzle on Windows server

We had similar problems. We could not figure out why our app was so slow. It
turned out to be the RAID5 on the server. We got info that database
applications should NOT run on RAID5. Try inserting an ordinary IDE disk and
compare.

Karl


"Sindre Solem" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi
>
> We're experiencing surprisingly low performance on one of our
installations.
> I guess it's related
> to the Windows network, but I'm not sure. I've tried various things to see
> if it has any impact on
> the issue.
>
> It's a Win2000 SP4 server with P.SQL 2000i SP4.
> It has a P4 2.4 GHz processor with 512MB ram.
> The disk system is SCSI with RAID 5.
>
> I'm running our application (developed with Visual DataFlex) locally on
the
> server.
>
> 1. When the files are read directly from physical disk, the performance is
> acceptable and about
> what I expect.
> 2. When the files are read from \\127.0.0.1\data\.... the performance is
> about the same as from
> physical disk. I guess this reads the data via the loopback interface.
> 3. When the files are read from \\servername\data\... (identical to how
the
> clients read the data),
> the performance is drastically degraded.
>
> Has anyone got a checklist of parameters or issues that could be
applicable
> in this situation?
>
> Next on my list is checking the network adapter.
>
> Regards
> -- 
> Sindre Solem
> Senior Systems Consultant
> Emma EDB AS
>
>