14

SQL Azure server in different region to web server

view full story
linux-howto

http://serverfault.com – I've just taken over a web project hosted on Windows Azure. We've been having performance problems, and I noticed today that our SQL Azure server is in the West Europe region, while the instances hosting our site are in the North Europe region. How big a problem is this? Assuming it's a problem (and I assume it is at least a problem from a bandwidth billing point of view!) how do I fix it? Is there an easier way to migrate than purchasing a second SQL Azure server in the correct region, taking the site offline, exporting from the current server, importing to the new server, modifying the (HowTos)

xskl's picture
Submitted by xskl on 01/20/2012 – Made popular on 01/20/2012

Stories similar to SQL Azure server in different region to web server

I have a couple of test servers on Windows Azure. One is in the North Europe location and the other is in West Europe.

Let's say you have a Windows Azure Virtual Machine preview account.

I would like to know if there is an easy strategy for migrating a Windows Server 2008 R2 installation from Amazon EC2 to Windows Azure. I would like to avoid reinstalling applications and recreating all the user accounts with the proper permissions.

I'm looking into splitting our database server and application server and am evaluating offerings from Rackspace and Azure specifically around the database server.

Possible Duplicate: Can you help me with my software licensing issue?

edit: Could not find an answer in the general response, this is very specific to Azure. Let me rephrase.

I am importing an image to Windows Azure's Virtual Machine. The OS I am imported is identical to one they offer.

When I try to connect to a named instance in a SQL SERVER hosted in a azure VM I get this message:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

I just created my first VM on Azure. It's a Ubuntu Server VM. The problem is that I can't ping anything. I created the endpoint with port 80, but after that it still didn't work. I then added it to the firewall and still nothing.

I feel stupid, but what exactly am I missing here? Does VM's made in Azure not automatically have internet?

TFS 2012 or TFS Azure (Preview) 40 weeks 19 hours ago

We want to migrate our current TFS 2010 solution that's hosted today in one of our own servers to TFS 2012 hosted somewhere else.

We don't want to handle the servers any more, and therefor are looking at alternatives.

I am using AWS micro instance for over a year and a half.

It is adequate for just serving a small website with SQLExpress. However it is very, very slow in all other cases. It shows 98 to 100% CPU usage while installing any new software, opening, closing, configuring the various tools and servers.

Im planning to move to Azure VM XS instance. It will cost about the same, once Azure VM goes GA.

We use a few Azure SQL servers. Each server has one database (partitioned per application modules). Almost each server has something sensitive.

Right now we've got protection per the following

SQL Server authentication (i.e.