When you run SQL Server on an Azure virtual machine or an Amazon EC2 instances there are certain weaknesses on these platforms that could cause unstable or poor performance in your databases. To arm yourself against this it is important to collect some information from your on-premises SQL Server before you migrate. This information will… Continue reading Prepare for a SQL Server to Azure or EC2 migration
Category: Azure
Azure VM SQL Server Disk Configuration
Azure VM SQL Server Disk Configuration Proper disk configuration is one of the most important determining factors of SQL Server performance. When running SQL Server on Windows Azure VMs this is even more important because Windows Azure VMs run on shared infrastructure where performance can vary. The following are some guidelines to follow when setting… Continue reading Azure VM SQL Server Disk Configuration
Chatty application performance on an Azure VM
A three tier application running on Azure VMs We were recently contacted by a customer because they had moved their application to a test environment on Azure and performance had become unacceptable. The application consisted of a three tier architecture: an HTTP layer, a middle tier of J2EE applications running on JBoss and the SQL… Continue reading Chatty application performance on an Azure VM