When diagnosing issues with long scan times, the following SQL can be useful in determining if there is a particular command that is taking a long time to execute. The output lists all commands executed and the average execution time

SELECT pa.Name as ProductAdapter, s.Name  as Strategy ,
label as CommandLabel, CommandText, avg(durationmilliseconds)/1000 as [Avg time (sec)] 
from [history].[t_CommandHistory] CH
join config.t_Strategy s on s.StrategyID=ch.StrategyID
join config.t_ProductAdapterConfiguration pa on pa.ProductAdapterConfigurationID=s.ProductAdapterConfigurationID
group by pa.Name , s.Name , label , CommandText
order by avg(durationmilliseconds) desc

Related articles

Page:

Active Directory SQL Authentication and the Scan Engine Service
Page:

Rename a Computer that Hosts a Stand-Alone Instance of SQL Server
Page:

Enable or Disable target logging
Page:

SQL Connection Error when credentials are correct
Page:

Rest API HowTo Articles