Tip of the Day: SQL Server Tips for VDBs

  • 1
  • Announcement
  • Updated 4 years ago
1. Number of VDBs per Delphix Engine:

Delphix 3.2.6 and older

Up to Delphix Engine 3.2.6, 85 VDBs is limited per Delphix Engine to a given Windows target server. This is due to 3 LUNs being assigned to each VDB and Windows having a limit of 255 LUNs per iSCSI target.
  1. Have multiple Windows target servers associated with a Delphix Engine 
  2. Have multiple Delphix Engines Associated with a Windows target server
Delphix 3.2.7 and newer From Delphix Engine 3.2.7 and newer, the number of VDBs per Delphix Engine to a given Windows target server is 255. This is due to reducing the number of LUNs to 1 per VDB.

2. Using Scripts:

  • For SQL Server dSources, pre- and post-scripts are incorporated into the validated sync process. 
  • For SQL Server single instance environments, scripts must exist and be readable on the staging environment.
  • Scripts can also be run as part of the SQL Server VDB provisioning process, in which case they must exist and be readable on the target environment.
  • For SQL Server, both dSource and VDB scripts can be either text or binary executables.
Photo of Delphix FAQs

Delphix FAQs, Official Rep

  • 3,980 Points 3k badge 2x thumb

Posted 4 years ago

  • 1

Be the first to post a reply!