Performance Guidance for SQL Server in Windows Azure Virtual Machines

Authors: Silvano Coriani, Jasraj Dange, Ewan Fairweather, Xin Jin, Alexei Khalyako, Sanjay Mishra, Selcin Turkarslan

Technical Reviewers: Mark Russinovich, Brad Calder, Andrew Edwards, Suraj Puri, Flavio Muratore, Hanuma Kodavalla, Madhan Arumugam Ramakrishnan, Naveen Prakash, Robert Dorr, Roger Doherty, Steve Howard, Yorihito Tada, Kun Cheng, Chris Clayton, Igor Pagliai, Shep Sheppard, Tim Wieman, Greg Low, Juergen Thomas, Guy Bowerman, Evgeny Krivosheev

Editor: Beth Inghram

Summary: Developers and IT professionals should be fully knowledgeable about how to optimize the performance of SQL Server workloads running in Windows Azure Infrastructure Services and in more traditional on-premises environments. This technical article discusses the key factors to consider when evaluating performance and planning a migration to SQL Server in Windows Azure Virtual Machines. It also provides certain best practices and techniques for performance tuning and troubleshooting when using SQL Server in Windows Azure Infrastructure Services.

Read on: Performance Guidance for SQL Server in Windows Azure Virtual Machines.

Comments

• Anonymous
  June 17, 2013
  Thanks for this, was an interesting read.

• Anonymous
  August 27, 2013
  I was trying to recreate what you have described in the white paper using a Windows server 2012 with 4,8 and 16 drives and add them in storage space. I ran into one issue while executing following: New-VirtualDisk –StoragePoolFriendlyName StoragePool1 –FriendlyName VirtualDisk1 –ResiliencySettingName Striping –UseMaximumSize The “ResiliencySettingName” value “Striping” does not exist. The possible value of “ResiliencySettingName” is “Simple, Mirror, or Parity”. See technet.microsoft.com/.../hh848643.aspx Can you please give details on how you created “ResiliencySetting” for striping. Thanks,