Workspace checkin form very slow

[iturner]

Over the last few weeks our Intralink has been gradually slowing down. There hasn't been any changes in number of users.

The worst operation is in w/s with 1000+ objects the checkin form or conflict window take 20 minutes to appear on screen. When we look at task manager there is minimal processor and minimal netwrok activity. The server also doesn't appear to be unser any strain. I have logged a call with PTC yesterday and I still waiting to hear back.

(we have also disabled the antivirus to eliminate that as a source of the problem)

I think server tuning might help but as the server is not heavily loaded I think the delay is on the client even though the local PC doesn't seem to be processing.

Anyone have any ideas?

[iturner]

I should have mentioned , this problem is affecting all users, and we
have tried the obvious deleting workspaces/.proi.

and we run ldbcompact on every intralink launch


Ian Turner

CAD Manager

Cobham Mission Equipment

[BrianSullivan]

Hello Ian,

Your Database Table Spaces are likely getting Full. Log into your Server and run the DSMU (proimgr.bat).
I would suspect that you have a Table over 90% Full.. Run the Space Report to find out. Increase your Oracle Database Tables (There is a menu in the DSMU for this) so that the tables are less than 45% full.

Also if on a Later Intralink 3.4.. some builds really take advantage of the Temp Space. A 1000+ Assembly can eat up 400MB of Table space per user checking out. On later 3.4 I like the Temp Space to be 2GB.

Brian Sullivan

[iturner]

Thanks for all the suggestions on speeding up workspace checkin - delete
.proi, check the ddb, enlarge oracle tables, .

Unfortunately none have worked and the problem affects all users,
working on those models. The assemblies are created using top down
techniques with skeletons.

I have done some further investigations and the problems seem to be
related to either the number of items in the 'relationship report' or
number of item in the 'where used' report. I would expect large
assemblies etc to take longer to generate the check in form but 20-35
mins is very slow. The problems started occuring in the last 2 weeks.

The really mystifying aspect is when the checkin form is generated there
is almost no processor load on the local PC (5%) and the server doesn't
really get above 25% processor usage. So what is intralink doing for 20
odd minutes, it is almost as if it is stalled and then the problem
clears after 20 mins.

I now wonder if it is related to top down design or maybe some intralink
configuration issue. The assemblies in question have about a 1,000
unique components but the same checkin problem can occur on individual
parts, but on other parts and assemblie,s the checkin form or conflict
form appear instantly even though it is the same workspace.

Ian Turner

CAD Manager

Cobham Mission Equipment

[igor-varshavsky]

Hello Ian,

Most likely your problem is related to Oracle tuning. The graduate slowing
down of the performance can indicate the fact that the amount of data in
Oracle table grows but Oracle does not take any action to change its
behavior and probably scanning in full huge tables in the files on the hard
drive instead of using indexes to speed-up the access process.
This can explain why your processor does not show any load on the server. I
believe that at the same time server's hard drive working like crazy.


You can take a look at the following knowledge base article that provides
some Oracle tuning hints for Intralink.

[pperry]

Ian,

Also remember the quantity of columns effects the amount of time to display any Intralink form. I would suggest creating an Intralink display that has the bare minimum of information displayed (i.e. name, rev, ver). Use prefrences to set this display as the default for the system check in form. It will not make it instantaneous, but it should help.

Pat Perry -- BAE Systems

[iturner]

I thought I would post a summary.... thanks to everyone for the
suggestions -- I had tried most of the suggestions.

Afte trying various intralink optimization parameters, suggested by PTC,
we had to build a new index within the intralink database (PTC R&D found
a solution).
SQL> CREATE INDEX "PDM"."PDM_DEPGR_COMPNAME_PI" ON
"PDM"."PDM_DEPENDENCYGRAPH" ("DGCOMPONENTNAME","PIID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)

TABLESPACE "PDM_INDEX" ;

The affected checkin forms now take 3 mins to display instead of 45
minutes.

I don't quite how we get this type of problem fixed once intralink
extended support ends.


Ian Turner

CAD Manager

Cobham Mission Equipment