SQL Performance

The maximum count of concurrent SQL connections that TWA uses can be configured in the TWA configuration file.

MaximumSqlConnectionCount has a default of 95 and should be left at this unless advised otherwise.

In General:

The command timeout used by TWA when using Sql Stored Procedures, typically for inserting/updating batches of data.

StoredProcedureTimeoutInSeconds has a default value of 120 seconds and should not be modified unless advised otherwise.