beautypg.com

Table 3 – Dell POWEREDGE R720XD User Manual

Page 9

background image

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on
PowerEdge R720xd

9

Drive Slot configuration:

Slot 0-17: Nine RAID 1 disk groups were created, each configured with a single Virtual Disk
dedicated for the primary user data.

Slot 18-21: One RAID 10 disk group was created of four disks and a single Virtual Disk dedicated
to host the database log files.

Slot 22-23: The remaining two disks were assigned as global hot spares.

Slot 24-25: Rear Bay Drives, One RAID 1 disk group for operating system and stage space.

For Fast Track architectures, Dell recommends that you use mount-point rather than drive letters for
storage access. It is also very important to assign the appropriate virtual disk and mount-point names
to the configuration in order to simplify troubleshooting and performance analysis. Mount-point names
should be assigned in such a way that the logical file system reflects the underlying physical storage
enclosure mapping. Table 3 shows the virtual disk and mount-point names used for the specific
reference configuration and the appropriate storage layer mapping. All the logical volumes were
mounted to the “C:\FT” folder.

Table 3. Mount Point Naming and the Storage Enclosure Mapping

Disk
Group

Virtual
Disk

Virtual Disk Label

Logical Label Full Volume Path

1

1

Cage1-Card1-vData1 Data1

C:\FT\PRI\Cage1-Card1-vData1

2

2

Cage1-Card1-vData2 Data2

C:\FT\PRI\Cage1-Card1-vData2

3

3

Cage1-Card1-vData3 Data3

C:\FT\PRI\Cage1-Card1-vData3

4

4

Cage1-Card1-vData4 Data4

C:\FT\PRI\Cage1-Card1-vData4

5

5

Cage1-Card1-vData5 Data5

C:\FT\PRI\Cage1-Card1-vData5

6

6

Cage1-Card1-vData6 Data6

C:\FT\PRI\Cage1-Card1-vData6

7

7

Cage1-Card1-vData7 Data7

C:\FT\PRI\Cage1-Card1-vData7

8

8

Cage1-Card1-vData8 Data8

C:\FT\PRI\Cage1-Card1-vData8

9

9

Cage1-Card1-vData9 Data9

C:\FT\PRI\Cage1-Card1-vData9

10

10

Cage1-Card1-vLog

Log

C:\FT\LOG\Cage1-Card1-vLog