<div>
Thanks for answers. Maybe one additional question about CPU cores assigned to VM throw Hyper-V. When server has 16 cores and I assign 4 (maximum) in Hyper-V manager to the virtual server, is it OK? I need to assign maximum performance to the virtual SQL server.<br />
<br />
Regards,<br />
Jarda
</div>


<div>
Sure, you can assign 4 vCPU to a VM (or even more) when the host has 16 physical cores. Depending on how busy the host is, it may not speed up the VM and may slow it down. The reason being that the host will need to have 4 physical cores available before it can execute any instruction for the VM. If the host is really busy, this means that the VM will spend more time waiting for the CPU than if it had two vCPU, which would be easier to schedule than 4 vCPU.
</div>


<div>
When SQL is virtualized there are a number of key factors to consider:<br />
&nbsp;+ IOPS needed for all databases<br />
&nbsp;+ Memory required for all instances in the VM<br />
&nbsp;+ Thread count required to process all database activity<br />
<br />
Bottlenecks in our experience are as above:<br />
&nbsp;+ Storage I/O<br />
&nbsp;+ Memory and NUMA boundaries<br />
&nbsp;+ Physical Core Count<br />
<br />
NOTE: vCPUs = Threads to the physical host. All threads must be processed in parallel throughout the CPU pipe. If more vCPUs than physical cores on 1 CPU get assigned to the VM then CPU logic needs to bounce threads between physical CPUs. This costs in performance.
</div>


<div>
<div class="content wysiwyg-content">
Dear experts, do you have experience with 2012R2 Hyper-V virtualized SQL server performance. <br />
I'm going to assign plenty of RAM and attach physical SSD hard drive RAID10 array to virtual server, but I'm afraid about degradation of CPU performance.<br />
<br />
Regards,<br />
Jarda
</div>
</div>


Dear experts, do you have experience with 2012R2 Hyper-V virtualized SQL server performance. 
I'm going to assign plenty of RAM and attach physical SSD hard drive RAID10 array to virtual server, but I'm afraid about degradation of CPU performance.

Regards,
Jarda

performance of Virtual SQL server (Hyper-V)

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Hyper-V is a native hypervisor; it can create virtual machines on x86-64 systems and supersedes Windows Virtual PC as the hardware virtualization component of the client editions of Windows NT. A server computer running Hyper-V can be configured to expose individual virtual machines to one or more networks. Hyper-V Server supports remote access via Remote Desktop Connection. Administration and configuration of the host OS and the guest virtual machines is generally done over the network.