db query table blocking issue on MSSQL Server with TS 6.6

edited February 28, 2014 in Documentum

Hello

Not overly familiar with xCP so coming in as a DBA.

Performance issues being hunted down.

Ran a trace for 8 hours and got 298 blocks between 2 and 5 seconds. Most blocks were part of blocking chains.

Blocks affected the following:

update dm_workflow_s set i_vstamp = i_vstamp where r_object_id = @P1

1. What is the point of this statement?

2. This is a Documentum 6.6 xCP system running on Windows 2008R2. Are there any known issues or advice in regards to entire table blocking and in the context mentioned.

Many thanks

Keith

Tagged:

Comments

  • edited February 27, 2014

    The i_vstamp attribute is used to track modifications.

    For example, if two users have write permit on a document then both could edit at the same time. This is allowed. The I_vstamp attribute is checked on save. In Webtop properties page the second user to save would be given a warning

  • PanfilovABPanfilovAB blog.documentum.pro
    edited February 28, 2014
    Blocks affected the following:

    update dm_workflow_s set i_vstamp = i_vstamp where r_object_id = @P1

    1. What is the point of this statement?

    To lock specific workflow object

  • Hi Keithbarnes
    Have you managed to solve that problem?

    Thank you for your help.
Sign In or Register to comment.