Software inventory processing is slow on a large Systems Management Server 2003 site (832335)


The information in this article 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 "Applies to" section.
Modification Type:MajorLast Reviewed:10/7/2004
Keywords:kbSMSTopazFix kbPerformance kbInventory kbQFE kbfix kbBug KB832335 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.