Dell PowerEdge R720xd Dell SMB Reference Configuration for Microsoft SQL Serve - Page 9

Table 3., Mount Point Naming and the Storage Enclosure Mapping

Page 9 highlights

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd 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 Virtual Virtual Disk Label Group Disk 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 9

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16

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