[dba-Tech] Access Performance on a WAN

with the newer sql server engine (sql server 2005 express) you can
deploy and Access/Sql solution where you will minimize the potential
for corruption by leveraging the power sql server w/o incurring the
additional license costs.  I'd look into that before looking into the
Access FE/BE.  Access is like a canary for networks.  Latency issues
surface rather quickly and even other problems such as noisy networks
will affect your performance, add to the mix the possibility of
corrupted BEs and you're asking for extra maintenance you don't want.




On Mon, 7 Mar 2005 14:09:59 -0500, Bobby Heid <bheid at appdevgrp.com> wrote:
> Dan,
> 
> Latency is the amount of time it takes for a data packet (i.e., a unit of
> data) to move across a network connection.  Latency and bandwidth are the
> two factors that determine the speed of your connection.
> 
> An example is with a hard drive, latency in this respect is the time between
> requesting the data form the HD and the actual transfer starting.
> 
> One of our clients wanted to do some stuff over a slow WAN that had network
> problems.  I told them that we would not support it.  I had a MS KB article
> that talked about it, but I cannot locate it at this time.
> 
> With the speed of that WAN, you may not have problems.  And since they are
> willing to test first...
> 
> Bobby
> 
> Bobby
> 
> -----Original Message-----
> From: dba-tech-bounces at databaseadvisors.com
> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Dan Waters
> Sent: Monday, March 07, 2005 1:55 PM
> To: 'Discussion of Hardware and Software issues'
> Subject: RE: [dba-Tech] Access Performance on a WAN
> 
> Bobby - what is latency?
> 
> And it will be agreed to by me and my customer before we start.  They said
> they can set up a test to simulate typical activities to see how it goes.
> 
> Dan
> 
> -----Original Message-----
> From: dba-tech-bounces at databaseadvisors.com
> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Bobby Heid
> Sent: Monday, March 07, 2005 12:19 PM
> To: 'Discussion of Hardware and Software issues'
> Subject: RE: [dba-Tech] Access Performance on a WAN
> 
> >From my understanding, you will do this at your own risk.  The speed is
> >not
> the issue, it is the latency.
> 
> Some people have implemented this without any problems, but I have read of
> others with lots of corruption and the like.
> 
> Bobby
> 
> -----Original Message-----
> From: dba-tech-bounces at databaseadvisors.com
> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Dan Waters
> Sent: Monday, March 07, 2005 12:52 PM
> To: 'Discussion of Hardware and Software issues'
> Subject: [dba-Tech] Access Performance on a WAN
> 
> Hello to Everyone!
> 
> I have a potential customer with a few different sites around the country.
> They have a WAN with 1.5 Gbit/sec capacity.  I said that I would like to do
> a test to see if this is feasible with Access XP, and they are willing to do
> that.  I can do a few things to minimize network traffic to help things work
> faster, but a test is still needed.  I do use a split FE/BE setup.
> 
> Does anyone have experience with this scenario?
> 
> Does 1.5 Gbit/sec correspond to 1.5 / 8 = 187.5 Mbytes/sec?
> 
> Thanks!
> 
> Dan Waters
> 
> ProMation Systems
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
> 


-- 
-Francisco
http://pcthis.blogspot.com | PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...