SQL 2012 Support

Question

Hello Masters!,

We are installing sQL 2012 on virtual systems and setting up active / passive cluster .  I would like to know virtual CPU support

Question:

how many virtual cpu should be configured per cluster node ? , what is the minimum VCPU support and maximum per cluster node

what is the VCPU support for overall cluster - eg 16 node cluster

how many servers are supported per cluster ( eg : 64 node single cluster ? or 64 servers in single cluster ? )

any considerations while setting up sql clusters on Virtual machines ?

please advise

Answer 1

http://msdn.microsoft.com/en-us/library/ms143432.aspx

http://www.vmware.com/files/pdf/solutions/sql_server_virtual_bp.pdf  ---VMware
http://www.vmware.com/files/pdf/SQLServerWorkloads.pdf ------VMware

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance

Answer 2

sorry not much configuration info I obtained from those 3 links

with hyper-v or vsphere I can have 32 VCPU per node so practically for 2 node the supported is 64 VCPU's max

Correct me if I am wrong : for clustering the SQL instances and the shared storage / storage is important and not the VCPU limit?

Do we need to consider Alwayson option rather conventional failover clustering ? ( we are running only sql 2012 and the older versions )

thanks bruvs :)

Answer 3

Always ON is the only SQL Server 2012 feature.

https://www.microsoftvirtualacademy.com/tracks/mission-critical-confidence-using-microsoft-sql-server-2012

http://www.sqlservercentral.com/articles/FCI/92196/

>>>Correct me if I am wrong : for clustering the SQL instances and the shared storage / storage is important and not the VCPU limit?

Sorry I have no idea.

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance

Answer 4

vCPU count has no bearing on Failover Clustering.  Systems do not have to have the identical number of processors.  The correct number of cores depends on the workload and your license.

---

Geoff N. Hiten Principal Consultant Microsoft SQL Server MVP