Suggest that Autodesk start to support locating the SQL distribution agent on a seperate server to avoid overloading a Vault publisher SQL node.
SQL is very resource heavy and by splitting the publisher into sections such as a dual node SQL cluster, ADMS Server and a Distributer Server it would greatly improve throughput and performance.
Currently the distributer resides on the same servers as SQL itself.
For large replicated environments this would be a very positive move and bring Vault in line with other enterprise database systems.
Thanks,
Kevin.
Group Vault Manager, Subsea 7.