Microsoft KB Archive/225533

= SMS: Inventory MIFs Processes Slowly =

Article ID: 225533

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 1.2 Standard Edition

-



This article was previously published under Q225533



SYMPTOMS

 * Inventory does not update in the Systems Management Server Administrator Console.
 * There is a backlog of files in the \sms\site.srv\dataload.box\deltamif.col subdirectory.
 * The site server disk fills with data.

After SQL Server tracing is enabled then the \sms\logs\datalodr.log has entries indicating that particular queries are taking an extraordinarily long time to complete. Below is a sample from a Datalodr.log where a standard query is taking over one minute to complete at the SQL Server file:

SQL>>>select * from MachineDataTable where dwMachineID = 18585~  $$ SQL>>>>> Done. $$ SQL>>>select * from MachineDataHistoryTable where dwMachineID = 18585~  $$ SQL>>>>> Done. $$



CAUSE
This behavior is representative of a site database that is missing one or more of the default Systems Management Server indexes. The default Systems Management Server indexes are created during installation and during service pack application. Many organizations drop and recreate the standard indexes during site database maintenance, if for some reason these indexes are not all recreated then there can be adverse affects on SQL Server operations including Management Information Format (MIF) processing.



WORKAROUND
NOTE: Always back up your site database before performing any operation that may make modifications to your site database directly.

The standard indexes can be recreated using the Upgrd12.sql file from the most recent service pack that was applied to the site. To recreate the indexes run this script against the site database as follows:


 * Connect as DBO or SA using ISQL/w to the Site database server.
 * Open the Upgrd12.sql file with ISQL/w.
 * Be sure that the site database is selected in ISQL/w.
 * Run the script to recreate any missing indexes.

<div class="moreinformation_section">

MORE INFORMATION
For additional assistance on troubleshooting MIF backlog problems and for instructions on how to enable SQL Server tracing see the following articles in the Microsoft Knowledge Base.

176517 SMS: Troubleshooting Inventory MIF Backlog Problems

166244 SMS: SQL Server Tuning Parameters for Systems Management Server

Additional query words: prodsms

Keywords: kbdatabase kbdataloader kbprb KB225533

-

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

© Microsoft Corporation. All rights reserved.