Documentum for Professionals
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…
