SQL Server in a VM
The SQL Server instance is installed within a VM guest. For the most part SQL Server does not know that it is running in a virtual environment. It expects to get resources in much the same way that it does in a non-virtualized environment. With that in mind, SQL Server should be installed and configured much like you would do in a non-virtual environment using standard SQL Server best practices. Two best practices that are particularly important in a virtual environment are:
1. Set the Maximum Server Memory in SQL Server. The memory that has been allocated to the VM and the memory needed by the VM guest OS need to be considered with this setting. SQL Server is capable of consuming all memory in a virtual machine and setting ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
