SQL Server 2008 introduced a new feature called “Hot Add CPU” that has generated a lot of excitement among database administrators. This feature allows for the addition of CPUs to a running SQL Server instance without requiring a server restart. While it may sound like a game-changer, it’s important to understand the limitations and considerations before deciding to upgrade.

One of the key restrictions of using the Hot Add CPU feature is the hardware compatibility. The motherboard of the server must support this feature, as not all hardware does. This means that if your current servers do not have the necessary hardware, you would need to invest in new servers that support Hot Add CPU.

Another requirement is the operating system. To use Hot Add CPU, you must be running either Windows Server 2008 Enterprise Edition or Windows Server 2008 Datacenter Edition 64-bit. It’s worth noting that 64-bit operating systems were not widely adopted at the time, and not everyone had upgraded to these specific editions of Windows Server 2008.

Furthermore, Hot Add CPU is only available in the SQL Server Enterprise Edition. This means that if you are currently using a different edition of SQL Server, such as Standard or Express, you would need to upgrade to the Enterprise Edition to take advantage of this feature.

Considering these restrictions, it becomes clear that the Hot Add CPU feature is not something that every organization will immediately benefit from. Upgrading to SQL Server 2008, investing in new hardware, and acquiring the Enterprise Edition can be a significant investment. It’s important to evaluate whether the benefits of Hot Add CPU outweigh the costs and whether your organization has a specific need for this feature.

In conclusion, while the Hot Add CPU feature in SQL Server 2008 is undoubtedly a cool and attractive feature, it is important to carefully consider the restrictions and requirements before deciding to upgrade. It may be more suitable for organizations with specific needs or those planning to invest in new servers with the latest technology. As with any technology decision, it’s crucial to weigh the benefits against the costs and ensure it aligns with your organization’s goals and requirements.

Reference: Pinal Dave (https://blog.sqlauthority.com)