Configuration settings for SQL Server virtual databases

Database configuration settings for a SQL Server virtual database can be provided as a key-value pair. Currently, there is support for the below-mentioned configuration parameter(s). These parameter(s) can be added in a configuration template and then applied to virtual databases.

The following parameters are available for SQL Server VDBs:

VDB Configuration Parameters

Value

Explanation

READ_COMMITED_SNAPSHOT

ON/OFF

Enables the READ_COMMITTED_SNAPSHOT isolation database option on the virtual database. By default, this option is set to OFF.

VDB config templates

A VDB config template is a list of database configuration parameter names and values that you can save on the Delphix Engine to use at a later time.

Creating a VDB config template via GUI

  1. Log into the Delphix Management application as an engine administrator.

  2. Click Manage.

  3. Select VDB Config Templates.

  4. Click the plus.png  icon next to the VDB Config Temp... and select New Template to create a new template. 

  5. In the New Template dialog window, enter the name for the new template, the parameters that you want to provide, and select the template type from the available options.

  6.  Click Create. 

Updating a VDB config template via GUI

  1. Log into the Delphix Management application as an engine administrator.

  2. Click Manage.

  3. Select VDB Config Templates.

  4. Select the template from the left-side pane that you need to update.

  5. Click on the pencil icons next to the parameters to edit an existing VDB template.

  6. To add a new parameter, click the plus icon, and enter a name and value of the parameter.

  7.  Click the Blue check.png button to save the changes or click the x.png button to discard the changes that you made. 

You can apply a VDB Config Template to a VDB during the provisioning process, which copies the values from the template. Any subsequent changes to the template will be reflected in the VDB when that VDB is refreshed/rewinded. During provisioning, you can specify configuration parameters directly or copy them from a VDB Configuration Template. Once set, the Delphix Engine will use these parameters whenever the VDB is refreshed/rewinded, even if you change the original template.