You experience slow performance when you search for a Microsoft Knowledge Base article in Microsoft Dynamics CRM 3.0

Consider the following scenario. You restart the Microsoft SQL Server 2005 server for Microsoft Dynamics CRM 3.0. Then, you search for a Knowledge Base article. In this scenario, you experience slow performance. When this problem occurs, Microsoft Dynamics CRM 3.0 takes a long time to return a result. Additionally, if the SQL time-out value is extended, you receive a SQL time-out error message that resembles the following error message:

This problem occurs because the DocumentIndex table contains the full-text index for the Microsoft Dynamics CRM Knowledge Base articles. The full-text index query causes a known issue in SQL Server 2005.

To resolve this problem, use one of the following methods.

Method 1

Add the following registry subkeys to increase the time-out values:

• OLEDBTimeout
• ExtendedTimeout

To do this, see "Method 1" in Microsoft Knowledge Base (KB) article 918609.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

Method 2

Turn off signature verification. To do this, use the workaround that is described in Microsoft Knowledge Base article 915850.

For more information, click the following article number to view the article in the Microsoft Knowledge Base: