ProjectWise Performance Report

Hello everyone,

For those of you at the conference, this was the dashboard I showed in my presentation and for those not at the conference, this is a dashboard on performance monitoring inside of ProjectWise using PowerShell.  Please find the attached documents to getting started with setting up performance monitoring on your system.  There is a PowerShell script that needs to be run on some kind of scheduled task at the various locations you want to test, the template for the PowerBi report and a setup document to help you link the results from your script with PowerBi.  For any questions or discussion please post to this thread.  Enjoy!

Thanks,

Marty

UPDATE March 16, 2020

Change log
- Now supports WSG metrics, activated with the -IncludeWSGData switch (requires PWPS_WSG to be installed if activated)
- Added more verbose logging
- Added Environment table and WSG table to output
- Updated the call to get currently connected users (should perform better)
- Now only clears files created by the script from the working directory (was previously clearing everything)
Notes
- If you do not want WSG data returned you do not need to activate the switch, or change your current script in any way.
- If you do with to collect WSG data please remember to install PWPS_WSG the same way you install PWPS_DAB
- A new datatable is returned for Environment data, which will be added to the output dataset
- No breaking changes have been made.

ProjectWise_Performance_Report_1.0.7zProjectWise_Performance_Report_Example_2.0.zip ProjectWise_Performance_Dashboard_1.0.zip

Parents
  • I have noticed that when running the report I get inconsistent results with the FolderCreate and FolderRemove times.  Here is my scenerio:

    The script is being run on a server, and the integration server/SQL database are in a different office

    If I run the script, the FolderCreate and FolderRemote totals are around 20s each (much more than it takes if done through the regular PW Explorer interface or just the new-pwfolder or remove-pwfolder command).  If I run the script again without closing my PowerShell session those same to tasks take less than a second.  What is the script doing the first time that it does not have to do the second time?

Reply
  • I have noticed that when running the report I get inconsistent results with the FolderCreate and FolderRemove times.  Here is my scenerio:

    The script is being run on a server, and the integration server/SQL database are in a different office

    If I run the script, the FolderCreate and FolderRemote totals are around 20s each (much more than it takes if done through the regular PW Explorer interface or just the new-pwfolder or remove-pwfolder command).  If I run the script again without closing my PowerShell session those same to tasks take less than a second.  What is the script doing the first time that it does not have to do the second time?

Children
No Data