Tempdb Log Exhausts the Available Disk Space When You Try to Update a Collection (830029)


The information in this article applies to:

  • Microsoft Systems Management Server 2003

SYMPTOMS

When you try to update a large collection, the size of the Templog.ldf file in the \Program Files\Microsoft SQL Server\MSSQL\Data\ folder increases. The tempdb log file increases until the disk space is full.

WORKAROUND

To work around this problem, move the tempdb transaction log to a disk partition that has more available free space. For more information about how to move a database, see "Attaching and Detaching a Database" in the SQL Server Books Online.

MORE INFORMATION

The size of the Templog.ldf file can increase under the following conditions:
  • You have a primary site that has many subsites attached. In such a hierarchy, the primary site may have many rule changes to process and replicate to the attached subsites. To process rule changes, the SMS Software Metering Processor runs a SQL query to write to the tempdb SQL database. The implicit transaction from the SQL query may remain open for a long time. This behavior prevents the truncation of the transaction log.
  • The replication of the SMS Software Metering summary data also locks transactions while returning data is streamed and is written to the summary file.
  • A large SMS fan-out hierarchy can decrease site performance. For example, you may experience delays when you generate advertisements. A large SMS fan-out hierarchy can affect all the SMS component services that replicate data to child sites. For example, a site with 3000 child sites may spend most of its time replicating objects. As a result, it cannot process other data.
  • User-defined collection queries may use large amounts of tempdb and tempdb log space when the collection is evaluated. For example, a query that returns many rows per computer and selects many computers can use large amounts of tempdb and tempdb log space. If the tempdb usage increases and much package or client data is not added to the SMS site database, examine any new collection query rules that were created, if any.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section of this article.
Modification Type:MinorLast Reviewed:6/13/2005
Keywords:kbsmsMeter kbusage kbPerformance kbinterop kbMiscTools kbnofix kbBug KB830029 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.