July 14th, 2023

Improvement

Business Manager

DBO: Data analysis: Parallel execution on SqlServer and pools (57855)

DBO: Dataanalysis: Parallel execution on SqlServer and pools

The analysis tool can execute the sql files in parallel on the target servers at the same time.

  • Each server is addressed in parallel.

  • In each server the pools and their databases are determined in parallel.

  • The databases are processed sequentially in the pools.

  • In each database the sql scripts are executed sequentially.

The goal is to allow pipelines to process faster and health checks to be added back into the SQL mapping.