Difference between MaxConcurrentDeletes and MaintenanceQueryRowLimit registry keys in Policy Server

Products

• CA Single Sign-On
• SITEMINDER

Issue/Introduction

Several registry parameters affect performance for ODBC and LDAP Session Stores exist in the following registry location, to optimize performance for ODBC and LDAP Session Stores (1).

HKEY_LOCAL_MACHINE\SOFTWARE\Netegrity\SiteMinder\CurrentVersion\SessionServer

Two of them are very similar but have small differences: MaxConcurrentDeletes and MaintenanceQueryRowLimit

What is the difference between MaxConcurrentDeletes and MaintenanceQueryRowLimit?

 

Resolution

 

1. MaxConcurrentDeletes (LDAP):
   
   This key defines how many requests would be sent to the LDAP server at the same time. It sends multiple delete requests without waiting for one to finish before sending the other one. 
   
   
2. MaintenanceQueryRowLimit (LDAP and ODBC):
   
   This key is more of a search limit, a chunk. It defines the search limit to be used when retrieving the list of objects to be deleted. 

In LDAP, delete is done in 2 steps:

1. Search (with limit);
2. Delete for each entry returned in the search;
        

In ODBC, delete is done as one (compound) command: 

1.  Delete + select (with limit);

 

Additional Information

 

1. Session Store Troubleshooting