Recommended Azure VM Sizes

Vertica supports a range of Microsoft Azure virtual machine (VM) sizes. These sizes are broken down into several types, such as memory optimized and high performance compute. In general, the general purpose, memory optimized, or storage optimized VM sizes are the best options for nodes in a Vertica database cluster. See the Sizes for virtual machines in Azure page in the Azure documentation for details about the different sizes.

The following VMs are available when you deploy Vertica from the Azure marketplace. They are a good choice if you plan to manually deploy your own cluster.

Optimization Type
General purpose

Standard_D8s_v3

Standard_D16s_v3

Standard_D32s_v3

Memory optimized

 

Standard_E8s_v3

Standard_E16s_v3

Standard_E20s_v3

Standard_E32s_v3

Standard_DS13_v2

Standard_DS14_v2

Standard_DS15_v2

Storage optimized

Standard_L8s

Standard_L16s

Standard_L32s

Other VM sizes available on Azure may also be suitable for your Vertica database cluster. When choosing custom VM sizes, take into account the hardware and network requirements for Vertica database nodes. See the following for an overview of the system requirements for a Vertica cluster:

Azure VMs have ephemeral disk storage by default. The data stored on ephemeral disks exists only while that VM is powered on. After powering off a VM, data on temporary drives is lost. If you are manually configure a cluster, do not use the emphemeral disk for data or catalog storage.