Hot Add CPU in sql server 2008

Explain Hot Add CPU in sql server 2008

CPUs can dynamically be added to a running system, by using Hot Add CPU feature. New hardware can be added physically and online hardware partitioning logically. A virtualization layer can be used to add this feature virtually.

Hot Add CPU feature allows a database for scaling on demand for extending memory resources added online, The CPU resources can be supported for SQL Server 2008 on hardware platforms that supports, without the need of application downtime

The following are the requirements for Hot Add CPU:
1. Hardware which supports Hot Add CPU
2. Windows Server 2008 Datacenter server of 64-bit or Windows Server 2008 Enterprise Edition for the Itanium-Based System operating system.
3. SQL Server Enterprise.
Extended events in sql server 2008
Extended Events are the enhanced event handling system in SQL Server. It is an architecture that is highly scalable, highly configurable..........
Explain SQL Server 2008 backup compression - Sql server 2008
A compression backup is smaller than uncompressed backup. The backup speed significantly increases because it needs less disk space and I/O operations..........
Explain Filestream storage of sql server 2008 - Sql server 2008
The complexity of application development and reduces the managing unstructured data cost...........
Post your comment