Is virtualization a good choice for SQL Server ?. Denny Cherry http://www.mrdenny.com firstname.lastname@example.org twitter.com/ mrdenny. About Me. Independent Consultant Founder of SQL Excursions Author or Coauthor of 5 books 8 + SQL Mag articles Dozens of other articles Microsoft MVP
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Is virtualization a good choice for SQL Server?
Used by host OS to request memory back from the guest OS
Prevents host of from paging physical memory to the hosts swap file
Should be enabled
Lock pages in memory should be disabled, unless enabled for a specific reason
Can greatly improve overall performance
By deduplicating OS virtual disks, we save much less data to the array
As less data is written to the array, less OS data is loaded into cache on the array