Hide Table of Contents

Vault Database Replication

SOLIDWORKS PDM Professional supports replicating a vault database that can improve performance in high latency (typically more than 50 milliseconds) and high usage environments.

Administrators can use AlwaysOn Availability Groups (AOAG) technology from Microsoft SQL Enterprise edition 2012 or higher. For details, see https://msdn.microsoft.com/en-us/library/ff878265.aspx.

For each availability group, AOAG maintains a single read-write primary database and multiple read-only secondary databases. The primary SQL server updates the secondary SQL servers periodically.

SOLIDWORKS PDM Web2 client and Web client cannot take advantage of the secondary database.

You can create the secondary SQL servers over LAN and WAN to the primary SQL server. Using AOAG, SOLIDWORKS PDM Professional can direct the read operations to the secondary SQL server. This improves the performance in the following ways:

  • Read operations are directed to the secondary SQL server, significantly reducing the load on the primary SQL server so it can respond faster, and handle more load.
  • For read operations, users access the secondary SQL database server instead of accessing the primary SQL database. This speeds up read operations such as browsing through vault folders, and accessing Data Cards, Contains, and Where Used information.
  • In case of high latency between the client and primary SQL Server, having a secondary SQL server locally to the client improves the performance for read operations.
It is recommended to use synchronous-commit mode on the secondary SQL servers that have very little latency to the primary SQL server.
All write operations are directed to the primary SQL server. During login, the user is connected to the:
  • Primary and secondary SQL servers if the secondary SQL server is reachable.
  • Primary SQL server if the secondary SQL server is not reachable. In this case, the primary SQL server handles all database operations for that session.


Provide feedback on this topic

SOLIDWORKS welcomes your feedback concerning the presentation, accuracy, and thoroughness of the documentation. Use the form below to send your comments and suggestions about this topic directly to our documentation team. The documentation team cannot answer technical support questions. Click here for information about technical support.

* Required

 
*Email:  
Subject:   Feedback on Help Topics
Page:   Vault Database Replication
*Comment:  

Print Topic

Select the scope of content to print:



x

We have detected you are using a browser version older than Internet Explorer 7. For optimized display, we suggest upgrading your browser to Internet Explorer 7 or newer.

 Never show this message again
x

Web Help Content Version: 2017 SP04

The search functionality within the web help is in a beta test phase and you may experience periodic delays or interruptions in its performance. These are the normal and ordinary features of a beta test and shall not under any circumstances give rise to any liability on the part of Dassault Systèmes SolidWorks Corporation or its licensors. The topics within the Web-based help are not beta topics; they document 2017 SP04.

To disable Web help from within SOLIDWORKS and use local help instead, click Help > Use SOLIDWORKS Web Help.

To report problems encountered with the Web help interface and search, contact your local support representative. To provide feedback on individual help topics, use the “Feedback on this topic” link on the individual topic page.