Grooming SCRM 2006 Data

  • Article

You can optionally schedule SCRM 2006 database grooming to delete inactive records that are no longer needed. Only data in the SystemCenterPresentation database is groomed, and the process deletes only those records that are marked inactive. If database space is not a concern, you do not need to groom your database. The default retention period is 365 days for all data. If any record has been marked inactive for longer than the retention period, it is deleted when grooming occurs.

The can set the properties of each grooming job in the SCRM Administrator console to do the following:

  • Enable or disable the grooming job.

  • Configure or reset the default retention period for data retention groups.

  • Enter credentials for the account that runs the grooming job.

  • Configure the schedule for the grooming job.

Grooming task actions are logged in the SC_MMC_GroomTablesLog table of the SystemCenterPresentation database.

Note

Before you schedule any grooming jobs, you should back up the SystemCenterStaging and SystemCenterPresentation databases. If database restoration is ever needed, you must restore both databases.

Data Retention Groups

Data Retention Groups are sets of related tables in the SCRM data warehouse, for which it makes sense to retain the data for the same period. Under Settings in the SCRM Administrator console, you can change the default retention period for each retention group by modifying values in either the MOM Data Retention Policy or the SMS Data Retention Policy.

MOM Data Retention

There is only one data retention group for MOM 2005 data, which is SC_ALL_MOM_DATA. This data retention group encompasses all MOM data from all MOM data sources in the SCRM data warehouse.

SMS Data Retention

The following are data retention groups for SMS 2003 data:

  • SoftwareInventoryRetentionGroup

  • HardwareInventoryRetentionGroup

  • ConfigurationDataRetentionGroup

  • StatusMessageRetentionGroup

Scheduling Grooming Jobs

Multiple grooming jobs cannot run simultaneously on a SCRM 2006 server. However, if a grooming job is running, any other scheduled grooming jobs are queued. A queued grooming job will run after other running grooming jobs have completed. The following grooming jobs are created when SCRM 2006 is installed:

  • SC_MOM_Grooming   Grooms all MOM data.

  • SC_SMS_Grooming   Grooms all SMS data.

MOM Grooming Jobs

The scheduled task for the MOM grooming job launches MOMGrooming.exe. Stored procedures are run to do the following:

  • Add an entry to the SC_MMC_JobHistory table.

  • Groom data from the MOM tables.

The following logging actions occur when a MOM grooming job runs:

  • MOMGrooming.exe logs to the SCAdminUI_MOMGROOM_<DateTime>_<ProcessID>_<UserName>.log file.

  • A new log file is created each time the grooming job runs.

SMS Grooming Jobs

The scheduled task for the SMS grooming job launches SMSGrooming.exe. Stored procedures are run to do the following:

  • Add an entry to the SC_MMC_JobHistory table.

  • Determine which tables need to be groomed.

  • Delete records from each grooming table based on the retention period.

  • Update the SC_MMC_GroomTablesLog table with grooming details.

The following logging actions occur when an SMS grooming job runs:

  • SMSGrooming.exe logs information to the SCAdminUI_SMSGROOM_<DateTime>_<ProcessID>_<UserName>.log file.

  • A new log file is created each time the grooming job runs.

  • When SMS data is groomed, the information is logged to the SC_MMC_GroomTablesLog table in the SystemCenterPresentation database.