Dell PowerEdge R510 - Manual (Page 10)

Dell R510 Reference Configuration for Microsoft SQL Server® 2008 R2 Fast Track Data Warehouse
Page 8
SQL Server Configuration
These startup options were added to the SQL Server Startup options:
 -E: This parameter increases the number of contiguous extends that are allocated to a
database table in each file as it grows. This improves sequential access.
 -T1117: This trace flag ensures the even growth of all files in a file group when auto growth is
enabled. It should be noted that the Fast Track reference guidelines recommend that you pre-
allocate the data file space rather than allow auto grow.
 Enable Lock Pages In Memory. Refer to Appendix for more information.
 -T834: Large Page Allocations.
Note : This flag should be tested thoroughly on a case-by-case basis. The validation for this
configuration does not include this trace flags. For more information on trace flags refer to the
Appendix.
Internal Storage System
The Fast Track reference architecture guidelines define three primary layers of storage configuration:
 Physical disk array (RAID Groups for Data and Logs)
 Operating system volume assignment (virtual disk)
 Databases: User, System Temp, Log
For each internal storage array:
 Four RAID 1 Disk Groups were created, each consisting of 2 disks. These RAID groups were
dedicated for the primary user data.
 One RAID 1 disk group was created of 2 disks. This RAID group was dedicated to host the
database transaction log files.
 The remaining 2 disks were assigned as the storage hot spares.
For the entire internal storage setup, there were eight disks dedicated to hold the primary user data
and two disks to hold the database log files.
For Fast Track architectures, we recommend 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 2 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 se1- v1 Data1 C:\ft\se1-v1
2 2 se1- v2 Data2 C:\ft\se1-v2
3 3 se1- v3 Data3 C:\ft\se1-v3