To test your MSDTC connectivity and performance:
Server |
SQL Server instance. Defaults to localhost. |
User |
User to connect to the SQL Server. For this variable you need to use the vRealize Automation service account to ensure you have proper permissions and access to the SQL database. If empty, uses Windows Auth. Defaults to empty (and thus, windows auth). |
Password |
Password to use, for the user. This value is ignored, if the User argument is not provided or is empty. |
Attempts |
Number of times to execute the query. Defaults to 101. |
Database | Database to use, Defaults to vCaC database. Use -Database parameter to provide an alternate DB name. |
The output of this shell script contains the MSDTC performance data. Generally, anything around 100ms is a good time and 500ms indicates an acceptable connection. Anything more than 1 second may indicate possible connection issues or lag that could cause problems with connectivity:
Count |
Number of times the query was executed |
Average |
Average of the query execution times (in milliseconds) |
Sum |
Total time of query execution for all attempts (in milliseconds) |
Maximum |
Highest time of query execution (in milliseconds) |
Minimum |
Smallest time of query execution (in milliseconds) |
Property |
Not applicable. Can be ignored. |