| Can we add CPU to SQL Server if yes then describe?
Yes we can add CPU to our SQL Server by either adding CPUs physically new hardware or by logically by online hardware partitioning or we can also add that by virtually through a virtualization layer. From Sql Sevre 2008 version sql server support CPU Hot Add means to add CPU minimum version is SQL Server 2008. Below are the some basic requirement to use CPU Hot Add.
(1)Hardware must support the CPU hot add.
(2)We have SQL Server Enterprise version to support CPU Hot Add.
(3)And when we say about operating system 64-bit edition of Windows Server 2008 Datacenter or Windows Server 2008 Enterprise Edition for Itanium-based system OS.
Kindly note once we add CPU we need to run RECONFIGURE and then SQL Server recongnizes the newly added CPU. | | |