The purpose of this article is to provide instructions for how to set up a SQL Maintenance Plan to maintain and/or improve general EPDM (now SOLIDWORKS PDM Professional) vault performance by scheduling a regular reorganization and rebuilding of EPDM Database Indexes. This procedure is based on the SOLIDWORKS Knowledge Base Solution ID S-042552 and recommended for all SOLIDWORKS Enterprise PDM customers.
Many tables in the file vault database contain indexes – to ensure data is found efficiently when lookups are done by various database operations. The SQL server automatically maintains these indexes whenever insert, update, or delete operations are made to the underlying data. Over time as you perform a lot of file operations in the vault - for example after an upgrade where a lot of records may have been modified, or performed a migration where many new records were added - the various database table indexes become scattered (fragmented - similar to how a hard drive can become fragmented). You can update and refresh the indexes by running a maintenance plan to rebuild/reorganize the indexes. If the indexes are very fragmented, this operation may improve general performance with searching, browsing, etc. in the vault.
The following should be taken into account when implementing an SQL Server Maintenance Plan
GoEngineer delivers software, technology and expertise that enable companies to unlock design innovation and deliver better products faster. With more than 30 years experience and thousands of customers in high tech, medical, machine design, energy and other industries, GoEngineer provides best-in-class design solutions from SOLIDWORKS, Stratasys, Altair, CAMWorks, Creaform and Product Lifecycle Management (PLM).
Get the latest articles delivered daily to your inbox, unsubscribe at any time.