Microsoft KB Archive/920065

= Performance issues occur when you filter a large CA database on a Windows Server 2003-based computer =

Article ID: 920065

Article Last Modified on 10/11/2007

-

APPLIES TO


 * Microsoft Windows Server 2003, Standard Edition (32-bit x86)
 * Microsoft Windows Server 2003, Enterprise Edition
 * Microsoft Windows Server 2003, Standard x64 Edition
 * Microsoft Windows Server 2003, Enterprise x64 Edition
 * Microsoft Windows Server 2003, Enterprise Edition for Itanium-based Systems

-





SYMPTOMS
Consider the following scenario. On a Microsoft Windows Server 2003-based computer, the certification authority (CA) database contains more than 1.2 million certificates. Additionally, the .edb file grows to a size of 7 gigabytes (GB) or more. In this scenario, the following symptoms occur:
 * When you run a query, the query requires an unexpectedly long time to run (one to two hours). Specifically, this symptom occurs when the query uses two filters that were created over an indexed field in the CA database.
 * When you use the CA Microsoft Management Console (MMC) snap-in to filter the CA database, this snap-in stops responding (hangs). Specifically, this snap-in stops responding for anywhere from 10 minutes to indefinitely. This behavior occurs in one of the following circumstances:
 * Immediately after you define the filter inside the CA MMC snap-in
 * When you try to switch between CA MMC folders and after you have defined the filter



WORKAROUND
There is currently no known workaround for the first symptom. To work around the second symptom, use the certutil command-line tool instead of the CA MMC snap-in for filtering operations. For example, use the following command:

certutil -view -restrict 



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: certsrv ICertView2

Keywords: kbtshoot kbprb KB920065

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.