vRealize Automation uses a Microsoft SQL Server database to store information about the vRealize Automation IaaS elements and the machines that vRealize Automation manages.
| 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. |
| 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 |
