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. vRealize Automation SQL Database Design Decisions

Decision ID

Design Decision

Design Justification

Design Implication

CSDDC-CMP-014

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

A dedicated or shared SQL server can be used so long as it meets the requirements of vRealize Automation.

Requires additional resources and licenses.

CSDDC-CMP-015

Use the existing cross-region application virtual network for the Microsoft SQL Server.

Provides a consistent deployment model for management applications and ensures that growth to a dual-region design is viable.

Requires implementation in NSX to support this network configuration.

CSDDC-CMP-016

Set up Microsoft SQL Server 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.

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 2012

Microsoft SQL Database Version

SQL Server 2012 (110)

Operating system

Microsoft Windows Server 2012 R2