• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

Preferred installation practice for MS SQL Server

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
posae
Asked:
posae
  • 2
1 Solution
 
Sir LearnalotCommented:
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
 
Sir LearnalotCommented:
Assuming you have the licenses ;) If this solution helped please mark it as the answer. Have a great day!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now