ASP SQL Server Application - Help with performance

Hi All

I have an ASP application which uses a single SQL Server based in London.

I have two webservers on which the code is hosted one in London and one in
New York both connect to the same SQL server database based in London.

The connection between London Webserver to SQL Server is fast but connection
from New York Webserver to SQL server is slow.

This is an internal setup and all servers are available on internal company
LAN. Connections to other offices are made through VPN.

Can anyone suggest some ways to speed up the access?

One thing I can think of is that putting a replicated SQL server is New YorK
will improve performance but I don't know much about replication

How does the new record id get assigned to new records between the two
servers?

Re: ASP SQL Server Application - Help with performance

Definitely sounds like a replication candidate to me.

http://msdn.microsoft.com/library/default.asp?url=/library/e n-us/replsql/repldata_078z.asp

for info on how to handle identity values between replicated SQL servers.

"JP SIngh" wrote in message
news:eFCNTDDlFHA.1412@TK2MSFTNGP09.phx.gbl...
> Hi All
>
> I have an ASP application which uses a single SQL Server based in London.
>
> I have two webservers on which the code is hosted one in London and one in
> New York both connect to the same SQL server database based in London.
>
> The connection between London Webserver to SQL Server is fast but
connection
> from New York Webserver to SQL server is slow.
>
> This is an internal setup and all servers are available on internal
company
> LAN. Connections to other offices are made through VPN.
>
> Can anyone suggest some ways to speed up the access?
>
> One thing I can think of is that putting a replicated SQL server is New
YorK
> will improve performance but I don't know much about replication
>
> How does the new record id get assigned to new records between the two
> servers?
>
>