By setting proper values for Timeout Detection Interval and Timeout Settings in AEM, PowerServer can release the timeout and invalid database connections in time, thus can avoid database deadlock or malfunctions, so that the concurrent processing ability and the running stability of PowerServer for .NET can be greatly enhanced.
The Session Timeout Detection Interval setting is to specify the interval (in seconds) to check whether sessions have timed out.
It is recommended that the value is smaller than the Session Timeout value. The default value is 30 seconds. The value recommended by the system is based on your Session Timeout values, if the Session Timeout values are different from applications, the system will multiply the smallest value with 0.15 to get the recommended value.
The Transaction Timeout Detection Interval setting is to specify the interval (in seconds) to check whether transactions have timed out.
It is recommended that the value is smaller than the Transaction Timeout value. The default value is 30 seconds. The value recommended by the system is based on your Transaction Timeout values, if the Transaction Timeout values are different from applications, the system will multiply the smallest value with 0.15 to get the recommended value.
Session timeout ends the user session and rolls back all database updates since the last commit for a user session. The default value is 3600 seconds. Session Timeout should be larger than the Transaction Timeout setting. Generally speaking, Session Timeout should not be smaller than 3600 seconds.
Transaction timeout rolls back all database updates since the last commit in a transaction. The default value is 120 seconds. Transaction Timeout should be less than Session Timeout.
If transaction timeout in the application database is set to 1800 seconds, then Transaction Timeout in AEM should be set to 1810 or larger.
If transaction timeout in the application database is not set, then Transaction Timeout in AEM should be set to a number greater than the maximum time needed to execute regular database operations for the Web application, suppose the most time-consuming table query operation takes 3600 seconds to complete, then Transaction Timeout should be set to 3610 or larger.
Specifies the maximum time (in seconds) to complete a rollback of a transaction. If the time to roll back transaction exceeds the specified value, the transaction rollback will be terminated. The default value is 3 seconds.
It is recommended that it is set to a number between 3 seconds and Transaction Timeout *0.1.
The maximum times to retry a rollback of a transaction. PowerServer executes a rollback if a transaction times out. If the rollback fails, PowerServer will keep retrying until this maximum value is reached. Setting this value to 0 will disable this feature. The default value is 3.
It is recommended that it is set to a number smaller than 10.
