Any idea about effects on performance and DB size, when automatic archiving of auditable links for work items is turned on?
Our RTC/RRC 5.0.2 still with Tomcat now on Windows server 2008. We have a request to turn on
automatic archiving of auditable links for work items.
Considering the issues we got in the past with out of resources (mostly OOM hangs), forum post 220347, and considering we only use Change Management (WI) and use it heavily:
Should we be concerned with the effects turning this feature on will generate on memory, performance, and DB space?
Wonder if we have similar feature for RRC links for artifacts?
Accepted answer
Note: I have not experimented with this functionality for JTS, RM, or QM, so all of my comments below refer to CCM.
There is some impact on disk space (since link deletion events are created), but normally, this is not significant (unless you have some background automated process continuously adding and removing links). It has some impact on displaying link history but normally this also is not significant (with same comment as above).
WRT the recent comment ... Link history works fine for me ... in particular, it always shows the addition of links (you do of course have to check the box in the upper right corner of the work item history pane which says "Include Link History").
Note that the addition of links are always shown in the history ... it is just the deletion of links that is not shown unless you have set this server property. When I set this server property, deletion of links (since the property was turned on) shows up fine in the history for me.
There is some impact on disk space (since link deletion events are created), but normally, this is not significant (unless you have some background automated process continuously adding and removing links). It has some impact on displaying link history but normally this also is not significant (with same comment as above).
WRT the recent comment ... Link history works fine for me ... in particular, it always shows the addition of links (you do of course have to check the box in the upper right corner of the work item history pane which says "Include Link History").
Note that the addition of links are always shown in the history ... it is just the deletion of links that is not shown unless you have set this server property. When I set this server property, deletion of links (since the property was turned on) shows up fine in the history for me.
Comments
Thx Geoffrey,
Suspect that we did not ' check the box in the upper right corner of the work item history pane which says "Include Link History" '.
Did find that we have had history of links creation all along with that box checked. Wonder if modifications of links would also have been recorded in WI history without, or would be with, that feature turned on.
Will be checking this feature again when we get a request to turn on this feature to be able to submit an RFC for it.
Comments
long TRUONG
Aug 23 '16, 2:16 p.m.The project team requesting for this feature, has since rescinded its request, due to other concerns on performance, hence we no longer pursue this in PRD.