Policy Server Guides › Policy Design Guide › User Directories › Configure SQL Query Schemes › Asynchronous Call Support During Failover and Connection Pooling › Asynchronous Call Support Configuration

Previous Topic: Asynchronous Call Support During Failover and Connection Pooling

Next Topic: ODBC Connection Pooling
Asynchronous Call Support Configuration

The following registry options are stored under the registry sub-key Netegrity\SiteMinder\CurrentVersion\Database

Option

Legitimate Values

Default

AsynchronousCalls

0 = no
1 = yes

0

Determines whether or not database calls will be made asynchronously

AsynchronousSleepTime

0 to n milliseconds

15 milliseconds

The amount of time between calls to wait before checking the status of an outstanding SQL call

LoginTimeout

minimum 1 (second)

15

SQL Timeout: The amount of time to allow for a connection to log in to the database

QueryTimeout

minimum 1 (second)

15

SQL Timeout: The amount of time to allow for a query to complete before canceling it.

Note: When SQL Server is running on Windows NT, asynchronous call support causes a very small memory leak per abandoned connection. You may choose to extend the timeouts to reduce the number of fail-overs in an unreliable network by adjusting the settings discussed in the table above.