How can I tell if multiple Transformation Servers are sharing the load evenly?
The job history table has a machine ID to indicate which system it processed on. Get a COUNT for each machine ID - if they are approximately equal, then they are running properly.
Differences in the count can be attributed to long running jobs vs. short quick jobs, so only a large discrepancy would warrant further investigation.
Please note that this should only be used for troubleshooting issues, since custom queries to the database could cause performance issues and are not supported.
Level of Complexity
Article # 3048430