July 19, 2016 at 1:41 pm
Greetings,
We are building a SQL Server 2014 (OLTP and OLAP) environment using VMWare virtual servers. My question is, what is the proper way to configure Virtual Memory at the guest-os level? I am trying to learn how the paging file is used in a virtual server environment and what impact it may have on SQL Server.
My thanks in advance.
July 20, 2016 at 1:54 am
There is no magic, if you don't make overcommit on host, vm should work OK.
General best practise is:
1. paging file: default, mssql try dont use paging file, but may be forced to use if you have overcommit on host
2. lock pages in memory: should be set, this help not pagging out mssql memory
You should reed https://www.vmware.com/files/pdf/solutions/SQL_Server_on_VMware-Best_Practices_Guide.pdf
July 20, 2016 at 8:21 am
Thank you e4d4.
I did read over the document that you linked and the book: https://www.amazon.com/Virtualizing-SQL-Server-VMware-Technology/dp/0321927753
I couldn't find a direct instruction regarding how to set the guest-os Virtual Memory configuration.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply