Microsoft KB Archive/298794

= PRB: Population or Query of a Full Text Catalog May Stop Responding =

Article ID: 298794

Article Last Modified on 7/16/2004

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q298794



SYMPTOMS
An attempt to populate or query a large full text catalog may stop responding (hang).

Also, queries and maintenance activities against the catalog may become unresponsive.



CAUSE
Virtual memory for the MSSEARCH process space is exhausted by the catalog caching operations.



RESOLUTION
The DWORD key MaxPropStoreCachedSize, in the HKLM\Software\Microsoft\Search\1.0\Indexer registry path, controls the amount of memory in megabytes (MB) that a catalog caches.

Adjust the MaxPropStoreCachedSize value accordingly to ensure proper virtual address space usage. Also, be cautious because a reduction in the cache size may affect performance.

IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



MORE INFORMATION
To determine if you are encountering the problem monitor the &quot;Virtual bytes&quot; performance counter in the &quot;Process&quot; group for Mssearch.exe. If the &quot;Virtual bytes&quot; value approaches the processes virtual memory limitation, then you are most likely experiencing the condition that causes a query to stop responding.

Calculate the number of active catalogs times the MaxPropStoreCachedSize and see if the value calculated approaches the process virtual memory limit.

Keywords: kbprb KB298794

-

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

© Microsoft Corporation. All rights reserved.