Viewing ACE Metrics

AdminStudio | Application Manager

Edition:This functionality is included in the AdminStudio Professional and Enterprise Editions.

When ACEs are run, Application Catalog generates metrics and logs them in the AceLog.txt file, located in the following directory:

AdminStudio Shared\ConflictSolver\AceLog.txt

The following is an example of the beginning of an AceLog.txt file:

11/06/03 09:26:35 ACE/CARD Execution started

 

----------------------------------------------

ACE03

----------------------------------------------

SELECT DISTINCT csmsiComponent.Component,

     csmsiComponent.ComponentId,csmsiComponent.RowID

     FROM csmsiComponent WHERE csmsiComponent.PkgRowID_ = 5

 

Records returned =>(124)

Query Time =>(0.23 seconds)

 

SELECT csmsiFile.FileName FROM csmsiFile WHERE

     csmsiFile.Component_ = 'DeletedLinks.10' AND

     csmsiFile.PkgRowID_ = 5

 

ORDER BY csmsiFile.FileName

 

Records returned =>(0)

 

Query Time =>(0.07 seconds)

 

Time taken to execute (ACE03) : 1.06 seconds

 

----------------------------------------------

ACE07

----------------------------------------------

SELECT [fs].[RowID], [ft].[RowID], [ft].[PkgRowID_],

     [ft].[FileName], [cs].[Component], [ct].[Component],

     [cs].[ComponentId], [ct].[ComponentId], [fs].[Version],

     [fs].[FileSize], [fs].[Language] FROM  (([csmsiFile] AS [fs]

     INNER JOIN  [csmsiFile] AS [ft] ON ( [fs].[FileName] =

     [ft].[FileName] AND [fs].[Version] = [ft].[Version] AND

     [fs].[FileSize] = [ft].[FileSize] AND [fs].[Language] =

     [ft].[Language]) ) INNER JOIN [csmsiComponent] AS [cs] ON

     [fs].[PkgRowID_] = [cs].[PkgRowID_] AND [cs].[Component] =

     [fs].[Component_]) INNER JOIN [csmsiComponent] AS [ct] ON

     [ft].[PkgRowID_] = [ct].[PkgRowID_] AND [cs].[ComponentId] <>

     [ct].[ComponentId] AND [cs].[csFullPath] = [ct].[csFullPath] AND

     [ct].[Component] = [ft].[Component_] WHERE  [fs].[PkgRowID_] = 5

     AND  [ft].[PkgRowID_] IN (4)

 

Records returned =>(0)

Query Time =>(0.10 seconds)

 

Time taken to execute (ACE07) : 0.74 seconds

 

----------------------------------------------

ACE08

----------------------------------------------

 

SELECT [cs].[Component] AS [SrcComponent], [fs].[RowID] AS [SrcRowID],

     [ft].[RowID] AS [TargetRowID], [ft].[PkgRowID_] AS

     [TargetPkgRowID], [fs].[Version] AS [SrcVersion],

     [fs].[FileName], [cs].[csFullPath], [ct].[Component] AS

     [TargetComponent], [ft].[Version] AS [TargetVersion] FROM

     (([csmsiFile] AS [fs] INNER JOIN [csmsiFile] AS [ft] ON

     [fs].[FileName] = [ft].[FileName]) INNER JOIN [csmsiComponent]

     AS [cs] ON [cs].[PkgRowID_] = [fs].[PkgRowID_] AND

     [cs].[Component] = [fs].[Component_]) INNER JOIN

     [csmsiComponent] AS [ct] ON [cs].[ComponentId] =

     [ct].[ComponentId] AND  [ct].[PkgRowID_] =

     [ft].[PkgRowID_] AND [ct].[Component] = [ft].[Component_] AND

     [cs].[csFullPath] = [ct].[csFullPath] WHERE

     [fs].[PkgRowID_] = 5 AND [ft].[PkgRowID_] IN (4) AND

     ([fs].[Version] <> [ft].[Version] OR ([fs].[Version] IS

     NULL AND [ft].[Version] IS NOT NULL) OR ([ft].[Version]

     IS NULL AND [fs].[Version] IS NOT NULL)

 

Records returned =>(0)

Query Time =>(0.09 seconds)

 

Time taken to execute (ACE08) : 0.73 seconds