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

Asynchronous Call Support Configuration

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

• AsynchronousCalls

  Determines whether database calls are made asynchronously.

  Values: 0 (no); 1 (yes)

  Default: 0

• AsynchronousSleepTime

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

  Values: 0 to n milliseconds

  Default: 15 milliseconds

• LoginTimeout

  The amount of time to allow for a connection to log in to the database.

  Values: minimum of 1 second

  Default: 15 seconds

• QueryTimeout

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

  Values: minimum of 1 second

  Default: 15 seconds

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 failovers in an unreliable network by adjusting the settings discussed in the table above.