Let's simulate running a workload on the virtual server. Simulate a Work Load for SQL Server Virtual MachineĪ VM guest is provisioned to present one vCPU on a Windows 2008 R2 SP1 Enterprise Edition that has SQL 2012 SP1 Enterprise Edition installed. To better understand the solution, the steps below will guide you. In order for SQL Server to start utilizing the hot-added vCPU online, the RECONFIGURE command needs to be executed each time a vCPU(s) is hot-added in order for SQL Server to create a scheduler for the hot-added vCPU. SQL Server by design does not automatically start using the hot-added vCPU when presented to the virtual server. The reference of vCPU in this tip refers to a CPU assigned to a virtual machine. This tip describes how to add a hot-add vCPU on a virtual server, but the methodology is the same to hot-add a CPU by physically adding new hardware or logically by online hardware partitioning. SQL Server on versions 2008 and higher have the capability to support hot-add CPUs, but there are some hardware and software requirements to be able to utilize hot-add CPUs. Can you describe how SQL Server is able to detect hot-added vCPUs in my virtual server? Solution Our VM administrator normally presents only 1 vCPU on the virtual server and extends as required. One of the benefits of running SQL on virtual environment is the capability to present additional vCPUs to the virtual server online and real-time without interruption to running processes. I have SQL 2012 Enterprise installed on a Windows Server 2008 R2 Enterprise Edition virtual server. By: Simon Liew | Updated: | Comments (3) | Related: More > SQL Server Configurations
0 kommentar(er)
