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?
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.