Microsoft KB Archive/286058

{|
 * width="100%"|

FIX: Incremental Population of Full Text Catalog Takes Longer than Original Catalog Creation

 * }

Q286058

-

The information in this article applies to:


 * Microsoft SQL Server 2000 (all editions)

-

BUG #: 351798 (SQL 2000)

BUG #: 351757 (SQL 2000)

SYMPTOMS
The incremental catalog updates associated with a SQL Server may take significantly longer than initial catalog population.

The behavior is such that even if no changes were made to the SQL Server data, the incremental full text catalog processing consumes a significant percentage of the CPUs and on average takes 4 to 6 times longer than the initial catalog population.

Specifically, the LSASS.exe process uses significantly more CPU than normal. LSASS.exe is the operating system process responsible for authentication.

CAUSE
The connections note being pooled when the row was missing or did not change. Additionally, the incremental population's connection pool is inadvertently timing out at 1.5 seconds instead of 15 seconds. The timeout can lead to a condition where each row gathered results in a logon and logoff.

RESOLUTION
A supported fix is now available from Microsoft, but it is only intended to correct the problem described in this article and should be applied only to systems experiencing this specific problem. This fix may receive additional testing at a later time, to further ensure product quality. Therefore, if you are not severely affected by this problem, Microsoft recommends that you wait for the next SQL Server service pack that contains this fix.

To resolve this problem immediately, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, please go to the following address on the World Wide Web:

http://support.microsoft.com/directory/overview.asp

NOTE: In special cases, charges that are normally incurred for support calls may be canceled, if a Microsoft Support Professional determines that a specific update will resolve your problem. Normal support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The English version of this fix should have the following file attributes or later:

  File name     Platform --

s80244i.exe  Intel NOTE: Due to file dependencies, the most recent hotfix or feature that contains the preceding files may also contain additional files.

STATUS
Microsoft has confirmed this to be a problem in SQL Server SQL 2000.

Additional query words:

Keywords : kbDSupport kbSQLServ2000bug

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ2000Search kbSQLServ2000