技术文章 - CS425173

使用 SQL Server 2022 的 Windchill PDMLink 13.0 中撤消检出的性能不佳

已修改: 29-Jan-2025   


适用于

  • Windchill PDMLink 13.0 to 13.1
  • SQL Server 2022

说明

  • 撤消签出在 SQL Server 2022 上的性能比在 SQL Server 2019 上的性能更差
  • PTC Windchill 13.0.1 版本矩阵指出“我们观察到,与使用 SQL Server 2019 的等效配置相比,撤消签出操作大约慢 20%”
    • 请注意,性能并不总是慢 20%
    • ~775 个对象仅慢 15%
    • ~2,000 个对象速度慢 26%
    • ~19,000 个对象实际上快 56%
  • 撤消签出的时间主要花在 IBA 的批量删除上
  • 以下堆栈跟踪负责这些删除:
O-cost=17285:DB DELETE: DELETE  FROM StringValue  WHERE (idA2A2 = ?):count=24
   O-cost=17285:wt.fc.profiling.SQLExecutionTimeProfilingLogger.addEndEntry(SQLExecutionTimeProfilingLogger.java:103):count=24
     O-cost=17285:wt.util.TraceTimingCompositeLogger.lambda$addEndEntry$1(TraceTimingCompositeLogger.java:41):count=24
       O-cost=17285:java.base/java.util.concurrent.CopyOnWriteArrayList.forEach(CopyOnWriteArrayList.java:807):count=24
         O-cost=17285:wt.util.TraceTimingCompositeLogger.addEndEntry(TraceTimingCompositeLogger.java:41):count=24
           O-cost=17285:wt.util.TraceTimingResource.close(TraceTimingResource.java:65):count=24
             O-cost=17285:wt.pds.SQLDatabasePds.deleteList(SQLDatabasePds.java:3680):count=24
               O-cost=17285:wt.pds.SQLDatabasePds.delete(SQLDatabasePds.java:2667):count=24
                 O-cost=17285:wt.pom.PersistentObjectManager.delete(PersistentObjectManager.java:628):count=24
                   O-cost=17285:wt.fc.StandardPersistenceManager.removeBatch(StandardPersistenceManager.java:2755):count=24
                     O-cost=17285:wt.fc.StandardPersistenceManager.remove(StandardPersistenceManager.java:2351):count=24
                       O-cost=17285:wt.fc.StandardPersistenceManager$DeleteBatchSpecChunkResultProcessor.process(StandardPersistenceManager.java:3630):count=24
                         O-cost=17285:wt.fc.AbstractOidChunkResultProcessor.process(AbstractOidChunkResultProcessor.java:147):count=24
                           O-cost=16127:wt.fc.AbstractOidChunkResultProcessor.addElement(AbstractOidChunkResultProcessor.java:78):count=22
                           |  O-cost=16127:wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:892):count=22
                           |    O-cost=16127:wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1077):count=22
                           |      O-cost=16127:wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:2052):count=22
                           |        O-cost=16127:wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:2004):count=22
                           |          O-cost=16127:wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1514):count=22
                           |            O-cost=16127:wt.fc.batch.BatchSpecificationUtilities.queryTargetKeys(BatchSpecificationUtilities.java:89):count=22
                           |              O-cost=16127:wt.fc.StandardPersistenceManager.execute(StandardPersistenceManager.java:1660):count=22
                           |                O-cost=16127:wt.iba.value.service.MultiObjIBAValueDBService.deleteAllIBAsForIBAHolders(MultiObjIBAValueDBService.java:548):count=22
                           |                  O-cost=16127:wt.iba.value.service.MultiObjIBAValueDBService$4.notifyVetoableMultiObjectEvent(MultiObjIBAValueDBService.java:278):count=22
                           |                    O-cost=16127:wt.events.StandardKeyedEventBranch.intDispatchEvent(StandardKeyedEventBranch.java:306):count=22
                           |                      O-cost=16127:wt.events.StandardKeyedEventBranch.dispatchVetoableMultiObjectEvent(StandardKeyedEventBranch.java:268):count=22
                           |                        O-cost=16127:wt.events.StandardKeyedEventDispatcher.intDispatchEvent(StandardKeyedEventDispatcher.java:306
这是文章 425173 的 PDF 版本,可能已过期。最新版本 CS425173