db query table blocking issue on MSSQL Server with TS 6.6

keithbarnes
keithbarnes
edited February 28, 2014 in Documentum #1

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

  • lastnitescurry
    lastnitescurry
    edited February 27, 2014 #2

    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

  • PanfilovAB
    PanfilovAB
    edited February 28, 2014 #3 
    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

  • Khaled_Farouk
    Khaled_Farouk
    #4
    Hi Keithbarnes
    Have you managed to solve that problem?

    Thank you for your help.

Categories