Skip to main content
1-Visitor
February 4, 2016
Question

State change and save as causing performance issue in windchill 10.1

  • February 4, 2016
  • 4 replies
  • 2403 views

Jesse State change and save as causing performance issue in windchill 10.1 can any suggest me for a fix@

4 replies

23-Emerald II
March 9, 2016

Rinceo, were you able to work past this performance problem? If not, can you provide further details about this issue? At what part of the process during the state change or Save As are you having performance issues? During data collection? When you launch the wizards for those actions? When you try to complete the action?

12-Amethyst
March 18, 2016

Is this only happen from Workspaces, with huge datas (2000+) in?

23-Emerald II
March 29, 2016

There are a few things that come to mind right off the bat as being possible culprits. See the following:

Main workspace performance tuning article:

http://support.ptc.com/appserver/wcms/standards/freefull_cskdb.jsp?&im_dbkey=105413&im_language=en

Circular dependency tracing:

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS51570

Slow running SQL (can test the following indexes):

  1. CREATE INDEX BaselineMember$ptc1 ON BaselineMember(idA3A5,idA3B5)
  2. CREATE INDEX StringValue$ptc1 ON StringValue(idA3A6,idA3A4)
  3. CREATE INDEX ApplicationData$ptc1 ON ApplicationData(role,idA2A2)

If you haven't done so already, it may be a good idea to open up a TS case. We have some SQL queries and additional tools that can be used to help figure out why these actions are slow if the above stuff doesn't take care of it.

March 29, 2016

Hello Rinceo

Can you please also check what is the cache Size

for Creo 2: Under files>Manage session>server management >cache>total cache used.

for Wf5:Under Tools>server management >cache>total cache used.