White Papers

Install and configure Windows Server 2016
18 Deploying the 65TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using
Dell EMC PowerEdge R640 and Dell EMC PowerVault ME4024 | 4023-CD-SQL
Execute the following steps for each volume, one at time, in order as the volumes are listed in Table 4:
1. Open ME Storage Manager and connect to the ME4 Series array.
2. Click the Storage tab.
3. Map the volume in the ME Storage Manager:
a. Expand the volume folder containing the volume.
b. Right-click the volume and select Map Volume to Server. The Map Volume to Server dialog
box appears.
c. Expand the server folder containing the server object.
d. Select the server object and click Next.
e. Review the information and click Finish.
4. Format the volume on the Windows server:
a. Open Disk Management.
b. Click Action in the menu bar and select Rescan Disks. Continue to rescan disks until the new
disk appears. It may take multiple rescans.
c. Right-click the new disk and select Online.
d. Right-click the new disk and select Initialize Disk. The Initialize Disk dialog box appears.
e. Under Use the following partition style for the selected disks, select GPT.
f. Click OK.
g. Right-click the unallocated space of the new disk and select New Simple Volume.
h. The New Simple Volume Wizard starts.
i. Click Next.
j. On the Specify Volume Size screen, keep the default size, and click Next.
k. On the Assign Drive Letter or Path screen, use the drive letter or mount point listed in Table 4
for the volume and click Next.
l. On the Format Partition screen, complete the following:
i. In the File system drop-down list, select NTFS.
ii. In the Allocation unit size drop-down list, select the value from Table 4.
iii. In the Volume label text box, enter the value from Table 4 and click Next.
m. Review the settings and click Finish.
Once the volumes have been mapped and formatted, perform the following steps:
1. Verify that the odd-numbered SQL Server data volumes are on one controller and the even-
numbered SQL Server data volumes are on the other controller. This can be corrected by remapping
the volume and specifying the correct controller.
2. Verify that the tempdb data volumes are on different controllers. This can be corrected by remapping
the volume and specifying the correct controller.
3. Create a folder named Data on each mount point under M:\ft, with the exception of
M:\ft\SQLSystem, by performing the following:
a. Open the File Explorer.
b. Select the mount point (for example, M:\ft\SQLData01) in the directory tree.
c. Right-click the mount point, select New, and select Folder.
d. Name the folder Data.
e. Repeat until all mount points (except for M:\ft\SQLSystem) have a Data folder.