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.
Thanks for this, was an interesting read.
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.