SCRM 2006 Performance Considerations
One of the most important functions of SCRM 2006 is to collect MOM 2005 and SMS 2003 data by means of Data Transformation Services (DTS) jobs. Performance of a full or delta DTS synchronization job primarily depends on the SCRM server database and hardware configuration.
Important
When processing software updates, the maximum number of data records that SCRM 2006 can process is 1 billion. To determine the number of data records in your processing environment, multiply the number of managed computers times the number of languages times the number of updates to be processed.
Database Sizing
It is important to perform disk space capacity planning before running synchronization jobs. Performance of the synchronization job might be reduced if the SQL Server increases the SCRM database file size while the Extraction, Transformation, and Load (ETL) synchronization process occurs.
You can mitigate the performance concern by ensuring that you have an adequate amount of disk space available on the SCRM server. Review the following guidelines before you run a full synchronization job for the first time:
Disk space Ensure that adequate free disk space is available on the SCRM 2006 and SMS servers to store Bulk Copy Program (BCP) files that are created when you configure a data source. The space required for the SCRM Inbound and Outbound folders on the SCRM 2006 server is approximately equal to 70% of the size of each SMS data source. The SMS site server must also have free disk space equal to or greater than 70% of the size of each SMS data source.
Database size Refer to the database disk space guidelines in SCRM 2006 Prerequisites. The SCRM ETL process uses the Tempdb database for its temporary object creation, so it is recommended that you configure the Tempdb on the fastest disk drive available. For more information on disk layout for better performance, see “RAID Levels and SQL Server” in SQL Server Books Online.
SCRM 2006 Performance Factors on an SMS Data Source
Performance of the SCRM data warehouse depends on hardware resources, software resources, and the database server configuration. Factors include the following:
Amount of data in the SMS site database
Size of the SMS site database
Number of SMS managed computers
Hardware inventory frequency
Software inventory frequency
Software inventory rules
Number of software update languages supported
Note
By default, one language is selected for software updates in SMS 2003 SP2. You can modify the Download.ini file in SMS 2003 to permit multiple language updates.
SCRM server hardware configuration
CPU type
Amount of memory
Hard drive configuration
Type of DTS job
Full data synchronization
Delta data synchronization
For information about SMS inventory frequency guidelines and best practices, view the SMS Product Documentation Web site (https://go.microsoft.com/fwlink/?linkid=9502).