vRealize Automation uses a Microsoft SQL Server database to store data relating to the vRealize Automation IaaS elements including information about 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 for managing Microsoft SQL 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 growth to two pod design is viable.

Requires implementation of 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 recommend separation of database data files and database transaction logs.

Requires consultation with the Microsoft SQL database administrators of the 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