db query table blocking issue on MSSQL Server with TS 6.6
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.