Dell-Specific RAID Settings - Teradata Database on VMware

Teradata Database on VMware Base, Advanced, Enterprise Tiers Getting Started Guide

Product
Teradata Database on VMware
Release Number
Deployer 3.01.01
Published
January 30, 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
ubd1516817713623.ditamap
dita:ditavalPath
TDVMWare_phase4a-4b_BAE.ditaval.ditaval
dita:id
B035-5958
lifecycle
previous
Product Category
Cloud

Teradata is a distributed database system and performance is better when the database system data drives are spread across multiple RAID-1 drive pairs. Each vNode/TPA instance requires 3 vdisks/datastores. If deploying a 4 vNode/TPA, a total of 24 internal drives are configured as RAID-1 pairs, resulting in 12 LUNs. Each one has a single datastore created using the entire LUN size. When the vNode/TPA instances are deployed, a single Teradata Database pdisk is created inside each datastore utilizing all of the datastore space.

The bundle of scripts help you configure the internal RAID storage to Teradata specifications. A second script is provided so you can create the datastores for each ESXi host if needed. The scripts that Teradata provides have been tested on Dell R720xd, R730xd and HP Gen9 pNodes. If you do not have these pNode types, the following are the Dell-specific RAID settings. It will be your responsibility to ensure the settings are correct as vendors use different setting names.

RAID-1 Settings
Setting Name Recommended Setting
Read Policy No Read Ahead
Write Policy Write Back
Disk Cache Policy Disabled
Stripe Element Size 64 KB