Your Browser is Out of Date

ShareDemos uses technology that works best in other browsers.
For a full experience use one of the browsers below
SQL Server 2019 on PowerEdge R640 vSAN Ready Nodes: Using VMware vSAN 7 and Red Hat Enterprise Linux 8
Appendix A
Best Practices Deployment procedure

Deployment procedure

  • Installing ESXi 7.0

    The R640 vSAN Ready Node server includes the iDRAC module that aids customers with hardware-level deployment and overview.

    Follow these steps:

    1. From Dell Technologies Online Support, download the iDRAC console, the Dell EMC ESXi 7.0 image, and additional information about the PowerEdge R640 server.
    2. Create a RAID 1 virtual disk on the Dell EMC BOSS drive as described on Page 21 of the Dell EMC Boot Optimized Server Storage-S1 User's Guide.
    3. Attach the ISO image to the iDRAC console by selecting Connect Virtual MediaCD/DVDChoose File, then browsing and selecting the ISO file for installation.

    When attached, the server reboots, and you have selected the boot process through the Lifecycle Controller.

    1. When you access the ESXi installer, select the VD created and configure the ESXi host with the required networking settings.

    Adding hosts to vCenter Server

    When ESXi is installed and configured on all target hosts, add and configure hosts in vCenter Server.

    Enabling vSAN

    After you add the hosts to the vCenter Client, enable vSAN while creating a cluster and adding a cluster name. When the vSAN is enabled, your hosts are in maintenance mode.

    1. Select the cluster. Under Configuration, click Quickstart and then click Configure, as shown in the following figure:

    Figure 10.          Configure the cluster

    1. Under Configure cluster, click Distributed switches, select the number of distributed switches required for the cluster, and then click Next.
    2. Configure the new switch by selecting the number of port groups, assigning port groups to the switch and NICs to be used across each server, and then click Next, as shown in the following figures:

    Figure 11.          Configure the switch

    Figure 12.          Configure the switch

    1. Under Storage traffic:
      1. Assign a vLAN (see Best Practices), as shown in the following figure:

    Figure 13.          Assign a vLAN

    1. Configure IPs for vSAN traffic, as shown in the following figures.

    Note: The autofill feature is useful to prevent errors and save time.

    Figure 14.          Configure IPs

    Figure 15.          Configure IPs using autofill

    1. Under Advanced options, select the options that apply to your deployment and click Next.
    2. Under Claim disks, claim disks for the cluster by following volumes best practices in Best Practices and click Next:

    Figure 16.          Claim disks

    1. Optionally, enable the vSAN Support Insight and configure proxy settings.
    2. Review all selections and click Finish to configure the cluster. 

    Creating policies for deployment

    When the cluster is configured, it is available for deployment of volumes, VMs, and so on. Before creating volumes, we recommended that you create a policy or edit available policies that govern the deployment of volumes.

    1. In the vCenter client, click Policies and Profiles, as shown in the following figure:

    Figure 17.          Select Policies and Profiles

    1. Click VM Storage Policies to view all the policies that are available by default, as shown in the following figure:

    Figure 18.          Select VM Storage Policies

    1. Do one of the following:
      1. Select a default VM storage policy.
      2. Click Create VM Storage Policy, complete the fields, and click Next, as shown in the following figure:

    Figure 19.          Create a VM storage policy

    Note: We created a new storage policy for our operating system and backup drives.

    1. Select options to define the policy structure and click Next.

    Note: We selected Enable rules for “vSAN” storage.

    1. Configure rules for availability and advanced policies based on the type of volumes and click Next, as shown in the following figures:

    Note: Select the type of rules carefully as they impact performance and space consumed significantly. For more information, see Volume layout.

    Figure 20.          Manage policy availability

    Figure 21.          Set advanced policy rules

    1. Review storage compatibility with the vSAN datastore, and then review and complete creating the Storage Policy.

    You can apply the policy for any volumes created on the vSAN datastore.

    Creating VMs

    Create VMs for running SQL Server. For information about how to create and manage VMs, see the VMware documentation.

    Note: To simplify deployment of multiple SQL Server VMs, we used the VMware cloning feature. For information about the cloning feature, see Clone an Existing Virtual Machine.

    Installing and configuring Red Hat Enterprise Linux

    After the VMs are created, install the Red Hat Enterprise Linux operating system. For step-by-step instructions and for more information about the installation, see Red Hat Enterprise Linux 8 installation tips and tricks.

    SQL Server 2019 on Red Hat Enterprise Linux supports the XFS file system, which we used for our deployment. We also used kernel settings for high performance and the specific tuned-adm profile. For information about how to enable these features, see Performance best practices and configuration guidelines for SQL Server on Linux.

    Installing SQL Server