Home > Workload Solutions > Oracle > White Papers > Oracle Big Data SQL on Dell EMC PowerFlex > Microsoft SQL Server storage configuration
We used a minimal storage configuration for our Microsoft SQL Server instance. Dell Technologies’ dedicated Microsoft customer team can work closely with our customers to configure databases for maximum performance and protection.
|
Oracle Big Data SQL |
|
|
||
Volume name |
VM disk configuration |
Description |
Size (GB) |
Number of volumes |
Total size (GB) |
TM_VM_SQL_OS |
VMFS |
Windows Enterprise Server |
800 |
1 |
800 |
TM_VM_SQL_STG |
VMFS |
Data files |
600 |
2 |
1,200 |
TM_VM_SQL_LOG |
VMFS |
Log files |
50 |
1 |
50 |
TM_VM_SQL_TEMPDB |
VMFS |
Temporary files |
500 |
1 |
500 |
The volume groups and storage volumes used with SQL Server consist of the following:
Note: The remaining volumes use VMware Raw Device Mapping (RDM). RDM points the virtual machine directly to the PowerFlex LUN, instead of a virtual disk file.