all groups > sql server connect > march 2005 >
You're in the

sql server connect

group:

recommended bandwith for remote sql server queries ?


recommended bandwith for remote sql server queries ? scott
3/31/2005 12:29:35 PM
sql server connect:
Hi,

It probably depends on the data transfer but is there a rule of thumb to
determine the upload bandwidth required to query a remote sql server ?

i.e I have IIS6 dedicated machine hosting a few sites. Each site hosts own
asp pages and pulls back XML over ssl from relevant SQL server hosted on
ADSL. There is never more than 10 concurrent user connections. I would like
each site to host its own sql database so i can query it live. What sort of
bandwidth do i need for this ? (assume 99.9 uptime and fixed IP)

IIS6
ASP pages
|
|
net_________________
| |
| |
site 1 site2
Sql server (ssl) Sql server (ssl)

Thanks for any help
Scott

Re: recommended bandwith for remote sql server queries ? Mike Epprecht (SQL MVP)
3/31/2005 6:32:43 PM
Hi

It depends on the application.

If it is badly written, a T1 line will not be enough. You have to test your
application to see what will give you acceptable performance.

There is no magic number, especially with XML and SSL.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]

Re: recommended bandwith for remote sql server queries ? scott
4/4/2005 9:21:52 AM
will do.

thanks for your time
Scott

AddThis Social Bookmark Button