Solved

Preferred installation practice for MS SQL Server

Posted on 2014-09-23
2
188 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
David Varnum recently wrote up his impressions of PRTG, based on a presentation by my colleague Christian at Tech Field Day at VMworld in Barcelona. Thanks David, for your detailed and honest evaluation!
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

786 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