http://www.sqlservercentral.com/blogs/sqlsailorcom/2012/07/26/capacity-considerations-while-moving-sql-workloads-to-a-virtual-world-/

Printed 2014/12/20 11:39PM

Capacity considerations while moving SQL workloads to a Virtual world !

By AnupWarrier, 2012/07/26

One of the most basic capacity considerations involved while planning to move SQL workloads to a virtual environment is to understand the maximum capacity of a single Virtual Machine (VM.

Many times questions arises in mind like “what is the max memory which a VM supports?”

Look at what one of the leading platform VMware vSphere 5 Enterprise Plus offers for a single VM -

These are pretty heavy numbers, and good enough to handle a tough SQL workload.

Windows Server 2012 Hyper-V also looks really promising [The RTM bits are scheduled to be released by Aug 12]

64 vCPUs per VM is really impressive and some other numbers which impressed me with Windows Server 2012 Hyper- V are -

Active VMs per Host  - 1,024

Maximum cluster nodes – 64 and Maximum VMs in a cluster – 4,000

Both VMware and Microsoft improved a lot when it comes to capacity per VM and thats really a good news.

Conclusion

Capacity limitation is not anymore a reason for you to move your SQL workloads to a virtual world. Come on in,the water is warm !!!



Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.