IaaS uses a Microsoft SQL Server database to maintain information about the machines it manages and its own elements and policies.

Depending on your preferences and privileges, there are several procedures to choose from to create the IaaS database.
Table 1. Choosing an IaaS Database Scenario

Scenario

Procedure

Create the IaaS database manually using the provided database scripts. This option enables a database administrator to review the changes carefully before creating the database.

Create the IaaS Database Manually.

Prepare an empty database and use the installer to populate the database schema. This option enables the installer to use a database user with dbo privileges to populate the database, instead of requiring sysadmin privileges.

Prepare an Empty Database.

Use the installer to create the database. This is the simplest option but requires the use of sysadmin privileges in the installer.

Create the IaaS Database Using the Installation Wizard.

Database Growth Settings

The vRealize Automation IaaS database must be configured with appropriate growth settings to maintain system performance and integrity. These settings allocate memory for database components and log files to grow as your system runs and processes data. VMware provides default growth settings that are applied automatically when the database is created through the installer or with supplied scripts. If you set up your IaaS database manually, you must configure the appropriate growth settings.

The following table shows the default vRealize Automation IaaS database growth settings.

Table 2. Default IaaS Database Growth Settings

Initial Size

Autogrowth

Maximum Size

Database

1024 MB

By 1024 MB

Unlimited

Log File

512 KB

By 10 %

Limited to 2 TB

You can use Microsoft SQL Management Studio to set or review your database growth settings if needed. While you can increase the growth settings as desired for your system configuration, do not set them lower than the VMware recommendations. Doing so, may affect system performance or cause other problems.

You can also set database growth settings with scripts. The script commands to set the IaaS database to VMware defaults are as follows. In these examples, "dbname" is the name of the database. 

ALTER DATABASE dbname
MODIFY FILE
(NAME = dbname, MAXSIZE = UNLIMITED, FILEGROWTH = 1024MB)


ALTER DATABASE dbname
MODIFY FILE
(NAME = dbname_log, MAXSIZE = UNLIMITED, FILEGROWTH = 10%)