Documentum for Professionals
In this article, we will learn how to identify and resolve Index Fragmentation in SQL Server. Index fragmentation identification and index maintenance are important parts of the database maintenance task. Microsoft SQL Server keeps updating the index statistics with the Insert, Update or Delete activity over the table. The index fragmentation is the index performance…
In the world of enterprise content management, Documentum stands out as a robust platform for managing and storing vast amounts of content. When dealing with multiple business units or departments, one important architectural decision is whether to create a single repository for all content or to separate repositories for each business unit. Here, we’ll explore…
Sometimes, you will notice this sql is taking over 34 sec instead of 0 sec. select all max(dm_document.r_modify_date) “maxdate” from dm_document_sp dm_document, dm_sysobject_r dm_sysobject_r2, dm_folder_rp dm_folder_r1 where (dm_document.r_object_id = dm_sysobject_r2.r_object_id and dm_sysobject_r2.i_folder_id = dm_folder_r1.r_object_id and dm_folder_r1.i_ancestor_id = ‘0b027183800008b3’) and (dm_document.i_has_folder = 1 and dm_document.i_is_deleted = 0) The original dql for this sql is: select max(r_modify_date)…
In today’s fast-paced digital world, the performance of applications plays a crucial role in user experience and business operations. There are few things more frustrating than an application suddenly becoming slow, leading to a cascade of negative effects, from user dissatisfaction to lost revenue. When an application slows down, one of the most common culprits…
IndexOptimize is the SQL Server Maintenance Solution’s stored procedure for rebuilding and reorganizing indexes and updating statistics. IndexOptimize is supported on SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance. Download…
Summary In Documentum Server, what are the general best practices guidelines for performance tuning of SQL Server databases? This issue was reported in (but may not be limited to): Documentum Server 7.0, 7.1, 7.2, 7.3, 16.4 Resolution Configurations on the SQL Server side Here are the recommended SQL Server configurations, according to our general performance…
Run the following SQL query, and check how long it will take. This might be the root cause. This query is being called from xCP viewer: select all max(dm_document.r_modify_date) “maxdate” from dm_document_sp dm_document, dm_sysobject_r dm_sysobject_r2, dm_folder_rp dm_folder_r1 where (dm_document.r_object_id = dm_sysobject_r2.r_object_id and dm_sysobject_r2.i_folder_id = dm_folder_r1.r_object_id and dm_folder_r1.i_ancestor_id = ‘0b027183800008b3’) and (dm_document.i_has_folder = 1 and dm_document.i_is_deleted…
Summary In Documentum xCP, the standard application timeout value is 30 seconds. It is efficient for most user activities but in some cases it needs to be extended, for example to avoid timeout errors when running large Full Text searches or slow Real Time Queries. How do you increase the xCP Application timeout? This issue…
OpenText™ Documentum™ customers may experience issues with over-customization and extended use of the Webtop interface, a product they’ve relied on for 10-15 years. OpenText Documentum D2 offers a modern alternative, designed to enhance productivity and meet the needs of both casual and power users. Upgrading to D2 can provide a more streamlined, future-proof interface for…
In today’s fast-paced digital world, efficiency and user experience are paramount. Enter Documentum Smart View—a sleek, modern user interface designed to revolutionize content management. Smart View provides a responsive, intuitive platform that adapts seamlessly across devices, allowing users to effortlessly manage documents, tasks, and workflows. With its simplified design and robust functionality, Smart View enhances…
