Skip to main content
A
alonkar-21-Visitor
1-Visitor
July 23, 2013
Question

Poor performance observed in Add to Workspace with MS SQL 2005 Database+WC9.1M060

  • July 23, 2013
  • 1 reply
  • 1084 views

We are on Windchill 9.1M060 and migrated from Oracle to MS SQL 2005 recently.

Now users are observing Poor performance in below actions if performed in pro/e embedded browser.


Add to Workspace,

Workspace Rendering,

Checkout,

undo check out

Issue is happening frequently now.

If around 150 components are already there in workspace and user tries to add 2 components to same workspace it takes around 7 mins.

Any suggetions over performance improvements?

1 reply

L
LoriSood23-Emerald I
23-Emerald I
July 23, 2013

Can you verify if any of the following are applicable:

https://www.ptc.com/appserver/cs/view/solution.jsp?n=CS77509

https://www.ptc.com/appserver/cs/view/solution.jsp?n=CS56366

http://www.ptc.com/appserver/cs/view/solution.jsp?n=CS62243

If those don't yield any helpful results it may be a good idea to generate a Windchill profile or use the MS SQL Server tools to verify whether there is any long-running SQL causing the problem. It may be necessary to create/change some indexes to help improve performance.

I assume that this occurs in both standalone and embedded browsers?

A
alonkar-21-VisitorAuthor
1-Visitor
July 25, 2013

Hi Lori,

The issues is observed in case of embedded browser only not in standalone browser.

Best Regards,

~Amit Lonkar

L
LoriSood23-Emerald I
23-Emerald I
July 29, 2013

If you haven't done so already, you may want to open a Tech Support case for further investigation. It may be necessary to enable client-side debug logging as per CS48724 to get a better idea of what is going on the client to make the actions so much slower.

I also assume that this occurs with a new workspace cache and with the browser/java caches cleared, correct?

Terms & ConditionsCookie settingsAccessibility statement