Skip to main content
Delphix

KBA1251 Required Registry Settings for Optimal Database Performance and Stability

Applicable Delphix Versions

  • All versions

Issue

There are number of Windows registry entries that must be set in order to provide optimal performance and stability for virtual databases (VDBs) and staging databases. These settings are not necessary on the Windows Server hosting the source database.

Failure to properly set these entries can cause a wide variety of problems including:

  • Poor performance for VDBs
  • Poor performance for dSources (both ingesting database dumps/transaction logs and writing new ones)
  • VDBs and staging databases going offline frequently

Manually checking the registry entries is time consuming. Manually setting the registry entries is error prone. This article contains a PowerShell script that can check the registry for correctness and another that can set the entries.

Troubleshooting

As a Windows Administrator, run the "DelphixRegistryChecker.ps1" PowerShell script to get a report on the current registry values. Download the script here: DelphixRegistryChecker.ps1

Resolution

If the output from the "DelphixRegistryChecker.ps1" script reports any errors, these need to be corrected. Either manually run "regedit.exe" and correct the entries by hand or use the "DelphixRegistrySetter.ps1" script. Download the script here: DelphixRegistrySetter.ps1 

Additional Information

Following are some screen shots of illustrating the output generated by the scripts.

Running DelphixRegistryChecker.ps1 before updating the registry:

Registry_Before_Correcting.png

Running DelphixRegistrySetter.ps1:

Running_DelphixRegistrySetter.png

Running DelphixRegistryChecker.ps1 after DelphixRegistrySetter.ps1 has done its work:

Registry_After_Correcting.png