db query table blocking issue on MSSQL Server with TS 6.6
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
Comments
-
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
0 -
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?0 -
Hi Keithbarnes
Have you managed to solve that problem?
Thank you for your help.0
Categories
- All Categories
- 108 Developer Announcements
- 53 Articles
- 106 General Questions
- 144 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 899 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management