Specifications

A Principled Technologies test report 41
Dell Active System 800 converged infrastructure solution: User
collaboration performance
APPENDIX J – INSTALLING AND CONFIGURING THE DATABASE
WORKLOAD
For our medium utilization scenario, we installed Microsoft SQL Server 2012 on two VMs, one VM residing on
the first of our two Dell PowerEdge M620 servers, and the second VM residing on the second of our two Dell PowerEdge
M620 servers. For our high utilization scenario, we installed Microsoft SQL Server 2012 on two additional VMs, one VM
residing on the first of our two Dell PowerEdge M620 servers, and the second VM residing on the second of our two Dell
PowerEdge M620 servers.
Configuring the SQL Server VMs
After cloning, modify the four SQL VMs to each contain the following settings:
 Memory: 48GB
 Virtual Processors: 8
 Additional virtual disks:
o 1 x 295GB virtual disks for SQL database data (Thick provision lazy zeroed)
o 1 x 195GB virtual disks for SQL log data (Thick provision lazy zeroed)
Installing SQL Server 2012
1. Open the console for the VM or connect to the VM with RDP.
2. Mount the installation ISO to the VM.
3. Click Run SETUP.EXE. If Autoplay does not begin the installation, navigate to the SQL Server 2012 DVD, and
double-click.
4. If the installer prompts you with a .NET installation prompt, click Yes to enable the .NET Framework Core role.
5. In the left pane, click Installation.
6. Click New SQL Server stand-alone installation or add features to an existing installation.
7. At the Setup Support Rules screen, wait for the rule check to complete. If there are no failures or relevant
warnings, click OK.
8. Select the Specify a free edition and select Evaluation from the drop-down menu. Click Next.
9. Click the checkbox to accept the license terms, and click Next.
10. If no failures are displayed after the setup support files are installed, click Next.
11. At the Setup Role screen, choose SQL Server Feature Installation.
12. At the Feature Selection screen, select Database Engine Services, Full-Text and Semantic Extractions for Search,
Client Tools Connectivity, Client Tools Backwards Compatibility, Management Tools – Basic, and Management
Tools – Complete. Click Next.
13. At the Installation Rules screen, click Next after the check completes.
14. At the Instance configuration screen, leave the default selection of default instance, and click Next.
15. At the Disk Space Requirements screen, click Next.
16. At the Server Configuration screen, check that NT AUTHORITY\SYSTEM is selected for SQL Server Agent and SQL
Server Database Engine. Click Next.
17. Assuming there are no failures, click Next.
18. At the Database Engine Configuration screen, select Mixed Mode.