Solved

Preferred installation practice for MS SQL Server

Posted on 2014-09-23
2
193 Views
Last Modified: 2014-09-23
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!
0
Comment
Question by:posae
  • 2
2 Comments
 
LVL 6

Expert Comment

by:Sir Learnalot
ID: 40339365
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.
0
 
LVL 6

Accepted Solution

by:
Sir Learnalot earned 500 total points
ID: 40339369
Assuming you have the licenses ;) If this solution helped please mark it as the answer. Have a great day!
0

Featured Post

Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Last article we focus in how to VMware: How to create and use VMs TAGs – Part 1 so before follow this article and perform the next tasks, you should read the first article how to create the TAG before using them in Veeam Backup Jobs.
Is your company's data protection keeping pace with virtualization? Here are 7 dynamic ways to adapt to rapid breakthroughs in technology.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question