Building Virtual SQL Server Environment
Please note this virtual SQL Server environment is created for practice only, the specification of this build does not reflect the ‘Real World’ specification that may be required for a production environment, the intended purpose of this build is to show how to build a virtual environment for learning purpose.
The first step I took as a DBA was to attempt to try installing and configuring a virtual machine, I used a virtual lab creation document (How to Build an Affordable SQL Server 2012 Lab) by Todd Kleinhans as guidance. Therefore, rather than me re-repeating all the steps and re-creating the document which would be pointless as I found the document straightforward to follow. I am going to share the document below and the specification/requirements I used for my virtual lab setup.
I would personally recommend any junior DBA to attempt this lab as it provides the overview of how things connect/communicate and are configured with each other from the domain controller to each environment.
Further recommended labs: Shared storage (ISCSI target for shared volumes), Cluster Setup, SQL Server Failover Clustering, SQL Server AAG and SQL Server installation.
- WMWARE workstation. https://www.vmware.com/products/workstation-pro/workstation-pro-evaluation.html (Alternative virtualization software’s are available)
- Windows Server 2012 R2 evaluation for 180 days. https://www.microsoft.com/en-gb/evalcenter/evaluate-windows-server-2012-r2
- SQL Server 2016 Developer. https://my.visualstudio.com/Downloads?q=SQL%20Server%202016%20Developer&pgroup=
Note: the below virtual environment will not consume all the space given at the start. Besides, will consume less disk space as these virtual environments will be linked clones from gold builds.
The SQL-Storage was created after completing the virtual lab creation during ISCSI setup see the blog (Shared storage ISCSI setup) and Clusters were created after completing Lab creation and ISCSI setup see (Configuring Cluster).
|DC||40GB – C:\||2024MB||Windows Server 2012 R2|
|SQL-Storage||4GB – DATA – D:\
40GB – C:\
4GB – Logs – L:\
1GB – Backups – B:\
1GB – SQL Binaries – S:\
2GB – TempDB – T:\
|2024MB||Windows Server 2012 R2|
|SQL-CORE||40GB-C:\||2024MB||Windows Server 2012 R2|
|SQL-A||40GB – C:\||2024MB||Windows Server 2012 R2|
|SQL-B||40GB – C:\||2024MB||Windows Server 2012 R2|
|SQL-C||40GB- C:\||2024MB||Windows Server 2012 R2|
|SQL-D||40GB – C:\||2024MB||Windows Server 2012 R2|