Ensuring the Health of Enterprise PDM

Solidworks Enterprise PDM offers a number of tools and techniques to keep the software working efficiently and effectively and more easily identify issues when they presents themselves.  

Archive

1) Keep tabs on the Archive Server Log:

EPDM Administration /Your Server /RMB /Show the Archive Server Log.

2) Review the replication monitoring too (when applicable).

– in the Administration tool you have the archive status dialog showing the total number of versions needing replicating to a particular server.

By right-clicking the node you can get a list of files not yet replicated to a server.

You can also use the SQL query to get a list of files needing replicated

Client

3) EPDM Client log:

EPDM Administration /Local Settings /Log File.

This log file gathers information from different components of EPDM system and

often, messages from these applications have the error descriptions that received from SQL Server.

4) Windows Event Viewer /Application Log

– here you can find events from SQL Server (Event Source: MSSQLSERVER) and SolidWorks EPDM Database Server.

Database

5) Monitor the SQL Server error log available in the SQL Server Management Studio

By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.

6) Also available is the Activity Monitor component of MS SQL Server Management Studio to get information about users connections to the Database Engine and the locks that they hold.

/RMB /Activity Monitor.

7) You can set up email alerts to help monitor EPDM file vault databases in MS SQL Server:

8) Keep an eye on space used and available. i.e. Free space on the local drives that SQL Server and Archive Server are using and the transaction log size and on the trace files numbers/ size.

9) Make regular backups of:

  • Vault Databases and ConosioMasterDb:
  • Archive Server Settings:

    Archive Server Configuration Tool /Menu /Tools /Backup settings.

File Vault Archives:

6 comments on “Ensuring the Health of Enterprise PDM

  1. Hello,
    Enterprise PDM is software from Solidworks that helps you control and manage your companies documents. It has many useful features such as custom workflows to adjust to your company processes, revision control to ensure sharing and working with the most current files and secure access via server. The interface is friendly as it is built right into windows explorer.
    It may be useful to many types of businesses but it is particularly useful to engineering groups and in conjunction with solidworks CAD software. If you would like, i can put you in touoch with a representative who may answer your questions directly and perhaps schedule a demonstration.
    Have a great day!

  2. CAD software is computer aided design. Engineers use it to create models and drawings of parts and assemblies the company wishes to build and sell as products or in the manufacturing process.

Leave a Reply