Re: MS Small Business Server 2003 & Btrieve
- From: "Bill Bach" <goldstar@xxxxxxxxxxxxx>
- Date: Thu, 26 Jan 2006 17:50:48 -0600
Try running the Pervasive SYstem Analyzer Network Communications Test
from the client to the server. Be sure to go into "Advanced" settings
and select TCP only, and set it for 2000 test packets.
While running, watch the screen count -- the counting should be fast
and smooth. If it runs slowly, or if you see it pause (any pause of
more than 1/4 second indicates a lost network packet), then you are
experiencing networking problems. Double-check NIC settings, duplex
settings, and other items to see what might be amiss.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach@xxxxxxxxxxxxxxxxxxxx
http://www.goldstarsoftware.com
*** Sydney: Pervasive.SQL Service & Support Class - 02/27/06 ***
*** Chicago: Pervasive.SQL Service & Support Class - 03/27/06 ***
Arch wrote:
> When moving an established application from a peer-to-peer network of
> W2k and XP machines to a client-server architecture using SBS 2003 we
> have suffered a performance degradition using both Pervasive 2000i and
> 9.1 using transactional access only.
>
> When run locally on the server, programs generally run twice as fast
> since the server is far more powerful than the former data host
> computer; however when run from a client, the response goes from 0:15
> to 1:45 on a particular program. Strangely, if you connect to the
> server using terminal services from the same LAN client, the test runs
> faster - on the order of 0:45. Not as fast as local (or pre SBS), but
> quite an improvement! The problem is not restricted to one program,
> but is apparent across the entire application. Report programs with
> sorts appear to be more affected than online screens - likely due to
> the higher volume of data.
>
> Ping time from client to server is under 1ms. You can Telnet from the
> client to the server on port 3351. Downloading a 9MB file from the
> server takes ~ 2 seconds. TCP/IP is the only protocol involved and
> the client's HOSTS file includes the server's fixed IP.
>
> Any thoughts would be appreciated. Pervasive tech support cannot find
> the answer...
.
- References:
- MS Small Business Server 2003 & Btrieve
- From: Arch
- MS Small Business Server 2003 & Btrieve
- Prev by Date: Re: pervasive code 94
- Next by Date: Re: DAT and IX Files
- Previous by thread: MS Small Business Server 2003 & Btrieve
- Next by thread: DAT and IX Files
- Index(es):
Relevant Pages
|
