SQL Server connection over the WAN

[J P Singh]

Hi All

We have a search page for one of our applications which connects to a SQL
Server database in SYDNEY. The IIS server on which the ASP page resides is
based in LONDON.

The performance of the search page is not great. It does work but takes
about 25 secs to display the results.

Can anyone offer some advice on how to enhance the performance of the ASP
application where the database is being accessed over the WAN?

Would it help if we move the application to the IIS server based in Sydney?

[Ray at]

"J P Singh" <noemail@asIhatespam> wrote in message
news:ugn5ua3rDHA.732@TK2MSFTNGP09.phx.gbl...

> Hi All
>
> We have a search page for one of our applications which connects to a SQL
> Server database in SYDNEY. The IIS server on which the ASP page resides is
> based in LONDON.
>
> The performance of the search page is not great. It does work but takes
> about 25 secs to display the results.
>
> Can anyone offer some advice on how to enhance the performance of the ASP
> application where the database is being accessed over the WAN?

Setup a SQL Server in London and replicate the data from Sydney.

>
> Would it help if we move the application to the IIS server based in

Sydney?

I would have to say yes! Is there a test server in Sydney that you can
install IIS on and test it?

You could always lease some OC lines for your WAN if you have a few extra
million dollars to spend every month.

Ray at work