October 2010
Intermediate to advanced
1008 pages
46h 16m
English
The SQL Server database role is the last but most challenging server role to virtualize. The server with the database role (otherwise known as the database server) needs the lion’s share of RAM and processor allocation. A minimum of four virtual processors and 8GB of RAM should be allocated to the database server. For best performance, though, at least 12GB of RAM should be allocated.
Like SharePoint VMs, SQL Server VMs require either fixed-sized or pass-through VHDs. The same disk considerations that apply to physical SQL Server machines apply to virtual SQL Server machines. So, be sure to allocate enough disk spindles for the database and logs volumes. In addition, be sure to follow standard best practices ...
Read now
Unlock full access