Virtual disk configuration
Virtual environments typically consist of different performance tiers of storage as a cost saving measure. Not all systems need premium storage.
During
BlackBerry AtHoc
’s performance testing, it was found that Solid State Device (SSD) volumes are needed for database transaction logs when deploying medium-to-large systems. Provisioned input/output operations per second (IOPS) may also be necessary depending on Storage Area Network (SAN) and VM host configuration. Please refer to the IOPS requirements below.The following storage disk configuration is applicable for both medium and large customer categories:
- Operating system files: RAID 5 (4 + 1 SAS 10,000)
- SQL data files: RAID 10 (8 + 2 SAS 10,000). This includes all user database data files.
- SQL log files: RAID 5 (4 + 1 SSD). This includes all user database log files. You should also put temporary DB (system database) data and log files both in this volume.
- SQL backup files: RAID 5 (4 + 1 SAS 10,000)
This disk configuration has led to peak disk IOPS and response times during the desktop client tests, as shown in the following table.
Customer category | Logical drive | RAID type | Disk IOPS |
|---|---|---|---|
Small | |||
DB Log Files | RAID 5 (SSD) | 2000 | |
DB Files | RAID 10 | 200 | |
Medium | |||
DB Log Files | RAID 5 (SSD) | 4300-4424 | |
DB Files | RAID 10 | 555-578 | |
Large | |||
DB Log Files | RAID 5 (SSD) | 5000 | |
DB Files | RAID 10 | 600 | |