I'm moving from a Rackspace Cloud platform to Azure but I'm having some real performance issues. It seems like everything is a little but slower but especially database interaction.
I've done some load testing with all the different Scale options for both the CPU and the Sql Database and they only get comparable to the Rackspace account when they're all maxed out which seems excessive. Let me clarify, the Azure system can probably handle more load with it's higher scale options but it's reaction time for one user is slower than Rackspace. I didn't write down what the exact load level was that Azure would be faster than Rackspace but it was much higher than the load we currently have.
I've been asked some specific questions like: Is the database and the web server in the same datacenter? I'm not sure how to check if they are but it seems like they aren't. Is there an option to have them in the same datacenter?
Another question was: Am I running Sql Server in a VM or using the service? I did not set up a VM, I went to the Sql Databases tab and created a database.
Is there anything that can improve the database performance for the Azure platform? Any way to decrease latency on connections?