SQL Server external performance

[adfox]

Hi All,

I am currently running a dedicated server, running web sites with ASP.NET and MSSQL.

I am wanting to buy some shared MSSQL hosting to use as an external database source but would like to know if the performance of my web sites will be hindered by the use of an external database compared to the database being run on my server.

Any ideas?

Thanks,

Andy

[sekasi]

You should worry a lot more about the amount of shared clients on the same web server or the same SQL server than anything else.

The fact that your web server has to throw a call to an external location will definitely affect the response time of your application however.

If you have the resources to set up a local database server that can make local network calls to and from your webserver, that's the best solution.

[jwilliam]

I'm with sekasi on the shared hosting. It can be rather sluggish and would, most likely, be the biggest problem you'd have. It's okay to access databases on other servers. In fact, some large web projects that utilize load balancing will utilize an sql database to store session data for multiple servers.

[sekasi]

I just wanted to inject that 'external' database server as in 'on the local network' is preferred to having it on the same machine.

But 'external' as in outside the firewall / local net is not awesome.

[adfox]

Thanks guys. It just confirms what I was already thinking, I am really just trying to assess if I can cut costs but the clients come first so I think its gonna have to be dedicated.

BTW, Sekasi, I love your portfolio site! Where abouts in Aus are you from? Was over there recently, its an amazing place - one day I may even decide to migrate. Whats the design industry like over there?