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

[alonkar-2]

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?

[LoriSood]

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?

[alonkar-2]

Hi Lori,

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

Best Regards,

~Amit Lonkar

[LoriSood]

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?