vRealize Automation uses a Microsoft SQL Server database to store information about the vRealize Automation IaaS elements and the machines that vRealize Automation manages.

Table 1. Design Decisions on the Microsoft SQL Server Database for vRealize Automation

Decision ID

Design Decision

Design Justification

Design Implication

SDDC-CMP-022

Set up a Microsoft SQL Server that supports the availability and I/O needs of vRealize Automation.

You can use a dedicated or shared Microsoft SQL server if it meets the requirements of vRealize Automation.

You must provide additional resources and licenses.

SDDC-CMP-023

Use the existing cross-region application virtual networks for the Microsoft SQL Server or set it up to have global failover available.

For failover of the vRealize Automation instance from one region to another, the Microsoft SQL Server must be running as a VM inside the cross-region application virtual network.

If the environment uses a shared Microsoft SQL server, global failover ensures connectivity from both primary and secondary regions.

Adds additional overhead to managing Microsoft SQL services.

SDDC-CMP-024

Set up а Microsoft SQLServer instance with separate OS volumes for SQL Data, Transaction Logs, TempDB, and Backup.

While each organization might have their own best practices in the deployment and configuration of Microsoft SQL Server, high-level best practices suggest separation of database data files and database transaction logs.

You must consult with the Microsoft SQL database administrators of your organization for guidance about production deployment in your environment.

Table 2. vRealize Automation SQL Database Server Resource Requirements per VM

Attribute

Specification

Number of vCPUs

8

Memory

16 GB

Number of vNIC ports

1

Number of local drives

1

40 GB (D:) (Application)

40 GB (E:) Database Data

20 GB (F:) Database Log

20 GB (G:) TempDB

80 GB (H:) Backup

vRealize Automation functions

Microsoft SQL Server Database

Microsoft SQL Version

SQL Server 2017

Microsoft SQL Database Version

SQL Server 2017 Standard or higher edition (64-bit)

Operating system

Microsoft Windows Server 2016