<div>
It is completely OK to install on a VM - just make sure enough resources are allocated to the SQL server VM. For example, virtualize 2 processors (each with 4 cores), 32 GB of RAM, e.t.c.
</div>


It is completely OK to install on a VM - just make sure enough resources are allocated to the SQL server VM. For example, virtualize 2 processors (each with 4 cores), 32 GB of RAM, e.t.c.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
We are doing more and more installations of SQL server and I have a question regarding server resource allocation. &nbsp;I hear from multiple people that certain versions of SQL Server utilize multiple cores/threads but installed on a virtual server, SQL is restricted in some way. &nbsp;Would someone be able to explain to me if it would be better to install SQL on VM server locally to utilize more resources or if it is ok to install on a VM?<br />
<br />
Thanks!
</div>
</div>


Hello,

We are doing more and more installations of SQL server and I have a question regarding server resource allocation.  I hear from multiple people that certain versions of SQL Server utilize multiple cores/threads but installed on a virtual server, SQL is restricted in some way.  Would someone be able to explain to me if it would be better to install SQL on VM server locally to utilize more resources or if it is ok to install on a VM?

Thanks!

Preferred installation practice for MS SQL Server

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

Virtualization is the act of creating a virtual (rather than actual) version of something, including (but not limited to) a virtual computer hardware platform, operating system (OS), storage device, or computer network resources. Virtualization is usually the creation of a system that executes separate from the underlying hardware resources, or the creation of an entire desktop for systems located elsewhere, similar to thin clients.

Virtualization

Servers are computing devices that are similar to desktop computers in that they have the same basic components, but are significantly different in size, configuration and purpose. Servers are usually accessed over a network, and many run unattended, without a computer monitor, input device, audio hardware or USB interfaces. Many servers do not have a graphical user interface (GUI), and are configured and managed remotely. Servers typically include hardware redundancy such as dual power supplies, RAID disk systems, and ECC memory, along with extensive pre-boot memory testing and verification. Critical components might be hot swappable, and to guard against overheating, servers might have more powerful fans or use water cooling.