cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

State change and save as causing performance issue in windchill 10.1

rcliff
6-Contributor

State change and save as causing performance issue in windchill 10.1

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

4 REPLIES 4
LoriSood
22-Sapphire II
(To:rcliff)

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?

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

LoriSood
22-Sapphire II
(To:tschweizer)

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.

Gagan
7-Bedrock
(To:rcliff)

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.

Top Tags