Owner's Manual

24 Deployment Guide
Table 1-2 and Table 1-3 show a simple layout for a two physical processor system.
NOTE: For more Storage Best practices, please refer to the Reference Architecture document on dell.com/sql.
Storage must be configured with a minimum of three virtual disks created and assigned to the node.
Table 1-2. Storage LUN Layout
Storage Processor Virtual Disks
SPA TEMPDB, DATA2, QUORUM
SPB DATA1, LOGS
Table 1-3. Storage Layout Example
Disk Number 01234567891011121314
Storage Layout Assignments
LUN1 —
Quorum
LUN2 —
TEMPDB
1+1
RAID 1/0
SPA
LUN3 — LOGS
2+2 RAID 1/0
SPB
LUN4 — DATA1
2+2 RAID 1/0
SPB
LUN5 — DATA2
2+2 RAID 1/0
SPB
HotSpare
Table 1-4. LUN/Virtual Disk Configuration and Sizes
LUN/Virtual Disk Minimum Size Number of
Partitions
Used For
Assign as many virtual disks to the database
as the number of processors in the node.
NOTE: For best performance it is recommended
to assign as many virtual disks to the database as
the number of processors in the node. For example,
if the node has two processors, assign two virtual
disks to the database.
Database size / n
For example, if there
are two LUNs/virtual
disks, each LUN/virtual
disk will be the size of
the database divided
by two.
1 Database
1 LUN/virtual disk Depending on required
temp database size
1 Temp database
1 LUN/virtual disk 10% of database size 1 Log file
NOTE: This is required for clustering only.
1 LUN/virtual disk
1 GB 1 Quorum disk