Virtual Machine Setup

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.

Required software:

 

Hardware Requirements

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).

Hostname Hard Disk Memory O/S
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

Technical Requirements

Hostname Domain IP Address Cluster
DC CONTOSO.COM 10.10.10.10
SQL-Storage CONTOSO.COM 10.10.10.20
SQL-CORE CONTOSO.COM 10.10.10.30
SQL-A CONTOSO.COM 10.10.10.40 SQL-CLUSTER01

10.10.10.80

SQL-B CONTOSO.COM 10.10.10.50
SQL-C CONTOSO.COM 10.10.10.60 SQL-CLUSTER02

10.10.10.90

SQL-D CONTOSO.COM 10.10.10.70

 

How to Build an Affordable SQL Server 2012 Lab Document:

how-to-build-an-affordable-sql-server-2012-lab

Leave a Reply

avatar
  Subscribe  
Notify of