Microsoft KB Archive/832335

= Software inventory processing is slow on a large Systems Management Server 2003 site =

Article ID: 832335

Article Last Modified on 10/25/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2003

-





SYMPTOMS
If you have a Microsoft Systems Management Server (SMS) 2003 site, you may experience slow software inventory processing when the following conditions are true:
 * The SMS database is very large. For example, the SoftwareInventory table contains millions of rows.
 * The SMS site is processing a large proportion of incoming software inventory that contains updates to the file modified date.



CAUSE
This problem may occur if there is a backlog of software inventory. This backlog may occur if a large proportion of the incoming software inventory contains updates to only the file modified date. Software inventory records that contain a change to only the file modified date are processed differently than software inventory records that contain changes to other file information. For example, software inventory records are processed differently when a file is created or is deleted.



RESOLUTION
To resolve this problem, obtain and install the latest service pack for SMS 2003. For additional information about how to do this, click the following article number to view the article in the Microsoft Knowledge Base:

885643 How to obtain the latest Systems Management Server 2003 service pack



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

Keywords: kbsmstopazfix kbperformance kbinventory kbqfe kbfix kbbug KB832335

-

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

© Microsoft Corporation. All rights reserved.