I'm trying to find a home for three ASP.NET 3.5 websites using three respective SQL Server 2008 databases. I've found one possible solution where I host the websites on a "semi-dedicated" environment with one specific provider. The problem is, the database piece of this service is lacking. So, I've found an additional solution where I host the databases with a different provider. This keeps me within budget and with two providers I respect a great deal. Unfortunately, neither provider gives me both site and database hosting as I'd prefer in one package.
My question is this:
1) Is there an definite downgrade of service if I separate the site hosting from the database hosting? As in, before I even test the possible latency, is this a bad idea? Has anyone done this successfully already?
2) Is there a good way to test the SQL Server response between those databases hosted on the same provider vs those hosted with a different provider? I'm not well-versed in testing site and database response over the Internet, so I'm vague on where to start.