As your SMS system accomplishes the tasks that you schedule and configure, SMS components continually add data to the site's database. As the amount of data grows, database performance declines.

Predefined maintenance tasks target the SMS site database and help to maintain its performance. Schedule these tasks to continually remove orphaned and out-of-date data, which are of no use to you or to the site. Reducing the size of the database by removing unnecessary data improves the performance and the integrity of the database, increasing the efficiency of the site.

To run a predefined maintenance task

1. In the SMS Administrator console, navigate to Tasks:

   Where?

   Systems Management Server>Site Database>Site Hierarchy><site code> - <site name>>Site Settings>Site Maintenance>Tasks

2. In the details pane, right-click the task that you want to run and click Properties.

3. In the task Properties dialog box, enable and configure the task. To minimize interference with the site operation, set the time period to off-peak hours of the site. The time period is the time interval in which the task can run. It is defined by the Start after and Latest start time specified in the task properties dialog box.

4. Click OK to save your settings. The task will now run according to its schedule.

If a task fails to run at first attempt, the SMS_SQL_Monitor service attempts to rerun the task until either the task runs successfully, or until the time period in which the task can run has passed. Predefined maintenance tasks log their activity to the SMS_SQL_Monitor log file (SMSdbmon.log).

The following predefined maintenance tasks are described in this section:

• Backup SMS Site Server

• Rebuild Indexes

• Monitor Keys

• Delete Aged Inventory History

• Delete Aged Status Messages

• Delete Aged Discovery Data

• Delete Aged Collected Files

• Delete Aged Software Metering Data

• Delete Aged Software Metering Summary Data

• Summarize Software Metering File Usage Data

• Summarize Software Metering Monthly Usage Data

• Clear Install Flag

On This Page

Backup SMS Site Server
Rebuild Indexes
Monitor Keys
Delete Aged Inventory History
Delete Aged Status Messages
Delete Aged Discovery Data
Delete Aged Collected Files
Delete Aged Software Metering Data
Delete Aged Software Metering Summary Data
Summarize Software Metering File Usage Data
Summarize Software Metering Monthly Usage Data
Clear Install Flag

Backup SMS Site Server

This task backs up an SMS site, including the SMS site database, SMS files, registry keys, and system configuration information. Backing up your site is an essential step when preparing the site for recovery in case your site fails. When recovering a failed site, having a comprehensive site backup greatly helps to restore the site to its original state.

Use this task to back up your site on a regular basis. For more information about backup and recovery and how to use this task, see Chapter 15, "Backup and Recovery."

This task is disabled by default.

Rebuild Indexes

This task reindexes all of the site's database indexes. An index is a database structure associated with a table that speeds up data retrieval. Because of this, searching indexed columns is much faster than searching non-indexed columns.

SMS uses many indexes to maximize the SMS site database performance. However, the SMS site database indexes are frequently updated to remain synchronized with the data, which is constantly changing. Frequent updates to indexes reduce their efficiency. This reduces the SMS site database performance and efficiency.

Use this task to rebuild all indexes in the SMS site database, which increases the efficiency of the SMS site database indexes and increases site performance.

Note

• In larger sites, administrators might want to have more control over the reindexing process. In this case, instead of running this task, administrators can set up an equivalent Database Maintenance Plan in the SQL Server Enterprise Manager.

This task is enabled by default, and scheduled to run every Sunday, between midnight and 5:00 A.M.

Monitor Keys

This task monitors primary keys and handles situations in which internal counters (that are used for SMS object IDs) roll over. A primary key is a column or combination of columns that uniquely distinguishes one row from any other row in a table.

Use this task to maintain the integrity of primary keys that are used in the SMS site database.

This task is enabled by default, and scheduled to run every Sunday, between midnight and 5:00 A.M.

Delete Aged Inventory History

If the hardware inventory feature is enabled at the site or at any of its child sites, then SMS is collecting hardware inventory data from clients on a regular basis, and storing that data in the site's database.

Use this task to delete from the SMS site database all hardware inventory history data older than the number of days specified in the task properties dialog box.

This task is enabled by default, and scheduled to run every Saturday, between midnight and 5:00 A.M, and to delete data that is older than ninety days.

Delete Aged Status Messages

This task deletes aged status messages. SMS generates status messages for all its activities at a fairly rapid rate. The number of status messages that are stored in the site's database, and how long they are kept in the site's database, depends on how you configured the site status system. The Delete Aged Status Messages task checks status filter rules to determine which messages need to be deleted. A large number of status messages impacts the site's database performance and uses a significant amount of disk space.

Use this task to delete aged status messages that are no longer needed from the SMS site database and from the site's hard disk.

Note

• Status messages are essential when monitoring SMS sites, especially when diagnosing problems at the site. Do not delete warning or error status messages until you have reviewed them, and you are sure that they are no longer needed.

This task is enabled by default and scheduled to run every day, between midnight and 5:00 A.M. Every time the task runs, it checks the settings in the Actions tab of status filter rules to determine which messages have expired. By default, status messages are kept for seven days.

For more information about configuring the status system, see Chapter 14, "Using the SMS Status System."

Delete Aged Discovery Data

This task deletes aged discovery data. If client discovery methods are enabled at the site or at any of its child sites, then SMS is collecting discovery data from clients and is storing that data in the site's database.

Use this task to delete from the SMS site database all data associated with resources that are no longer considered part of the SMS hierarchy. This task identifies resources that have not reported discovery data in more than the number of days specified in the task properties dialog box. The task deletes from the SMS site database all data (including hardware inventory, software inventory, and software metering data) referencing that resource, deleting the resource from the site.

This task is enabled by default and scheduled to run every Saturday between midnight and 5:00 A.M., and to delete data older than 90 days.

Delete Aged Collected Files

This task deletes aged collected files and orphaned software inventory records. If software inventory is enabled at the site or at any of its child sites, then SMS is collecting software inventory data and possibly files (if configured to do so) from clients on a regular basis. SMS stores software inventory data and information about the collected files in the site's database, and stores the collected files on the site server's hard disk (by default, up to five instances of each collected file).

When files and products are no longer inventoried, their respective records remain in the SMS site database, but they are orphaned. Software inventory records no longer reference them.

Use this task to remove orphaned software inventory records, and to delete collected files that are older than the number of days specified in the task properties dialog box. The task deletes the aged collected files from the site server disk, and removes from the SMS site database references to these files.

This task is enabled by default and scheduled to run every Saturday between midnight and 5:00 A.M. and to delete data older than 90 days.

Note

• Any aged collected files or orphaned software inventory records that are referenced by software metering data are not removed.

Delete Aged Software Metering Data

If the software metering feature is enabled in your site, then SMS is metering software on client computers, and is storing large amounts of software metering data in the site's database. Use this task to remove aged software metering data, and to conserve space in the SMS site database.

For more information about software metering maintenance tasks, see Chapter 8, "Software Metering."

Delete Aged Software Metering Summary Data

If the software metering feature is enabled in your site, then SMS is metering software on client computers, and is storing large amounts of software metering data in the site database. Use this task to remove aged software metering data, and to conserve space in the SMS site database.

Summarize Software Metering File Usage Data

If the software metering feature is enabled in your site, then SMS is metering software on client computers, and is storing large amounts of software metering data in the site's database. Use this task and other software metering maintenance tasks to summarize software metering data, and to conserve space in the SMS site database.

Summarize Software Metering Monthly Usage Data

If the software metering feature is enabled in your site, then SMS is metering software on client computers, and is storing large amounts of software metering data in the site's database. Use this task and other software metering maintenance tasks to summarize software metering data, and to conserve space in the SMS site database.

Clear Install Flag

When clients are installed, they are flagged by SMS with an installed status. Clients maintain their installed status even after they are uninstalled, thus preventing them from being reinstalled by the Client Push Installation method.

Use the Clear Install Flag task to flag uninstalled clients as uninstalled, thus allowing them to be reinstalled by the Client Push Installation method. If the Client Push Installation method is the only installation method enabled in the site, then you must enable this task to allow reinstallation of clients.

The task examines all clients in the database, and for each client, it checks whether the following two conditions are met:

• The client has not been recently discovered by the Heartbeat Discovery method, and not by the Windows NT Logon Discovery (SMS 2.0).

• The client is flagged as installed (such as when a client was previously installed, and then uninstalled.)

The task flags every client that meets both conditions with an uninstalled status. This allows the Client Push Installation method to reinstall these clients.

By default, this task is disabled. When enabling this task, set the rediscovery period to be longer then the Heartbeat Discovery interval to ensure that the task switches the client status only for clients that have been uninstalled.

Important

• If heartbeat discovery is disabled, running this task is useless. It cannot identify clients with the inappropriate installation status. If you disable heartbeat discovery, then disable this task.

For More Information

Did you find this information useful? Please send your suggestions and comments about the documentation to smsdocs@microsoft.com.