EPDM performance improvement and ProNor benchmark tool

With passing time, Solidworks Enterprise PDM starts slowing down. To avoid performance problems with time we have to monitor EPDM. This can be done using ProNor benchmark tool and by studying various SQL server parameters. In this blog, I will explain how to use ProNor benchmark tool and briefly about SQL server parameters.

Simple workflow for performance improvement:

img1

ProNor benchmark tool:

ProNor benchmark tool is an EPDM add in that records time taken for following activities

  1. Add folders
  2. Add files
  3. Check in files
  4. Move files
  5. Check out files
  6. Delete files and folders
  7. Destroy files and folders
  8. Set variables
  9. Clear cache
  10. Get latest version
  11. Run workflow transition

How it works?

Execute various actions on a pc. While the actions are executed, they will be recorded in a scenario. After scenario is recorded, execute it on different pcs. Result of scenario is stored in database and can be exported any time. Only latest result per pc per scenario is stored in database. Below is an example scenario

  1. Start scenario
    img2
  2. Add folders – Enter names folder1 and folder2, one in each line
  3. Add files – Select files that have to be added using the file selection dialog ( files can be inside or outside vault) and select “folder1” as destination folder in the folder selection dialog
  4. Check in files – Select files that have been added in previous step using file selection dialog
  5. Move files – Select the files that have to be moved using file selection dialog and select “folder2” as destination folder in folder selection dialog
  6. Set variables – Select files that have been moved using file selection dialog and enter Description as variable name and some value in value column
  7. Change state – Select files from previous step using file selection dialog and select transition name in the dialog that shows list of transitions
  8. Check out files – Select files from previous step for checking out using file selection dialog.
  9. Check in files – Select files from previous step for checking in using file selection dialog.
  10. Destroy folders created in step 2
  11. Stop scenario

After “Stop scenario” is pressed, user is prompted to select output folder for saving results file. Results are exported in html format. Completed scenarios can be seen by clicking on “Show Recorded Scenarios”

From above dialog, results can be exported for previously executed scenarios and scenarios can be re-run

Analyze SQL parameters and parameters on local pc

When benchmark tool is executed on different pcs, if time taken is more on some pcs when compared to others, analyzing the client pcs can help fix some of the problems

In general SQL server parameters affect all clients. So if performance on all clients is bad, analyzing SQL parameters will help identifying problems. SQL server performance can be affected because of following parameters

  1. Memory parameters
  2. Harddisk I\O parameters
  3. Processor parameters
  4. Network parameters

Using “perfmon.exe” and SQL DMVs, issues can be identified.

After issues are identified and fixed, execute saved scenario from ProNor benchmark tool to check if fixing of issues has actually improved performance or not

Periodic execution of benchmark tool and checking the timings will help in ensuring that performance of EPDM is good

Licensing for ProNor Benchmark tool:

Please contact support@pronor.com for licensing options

This entry was posted in SOLIDWORKS PDM and tagged , , , , , , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s