Improve Configuration Manager Performance: Rebuild Indexes and SQL Memory and Database Limits

Improve Configuration Manager Performance: Rebuild Indexes and SQL Memory and Database Limits. In this guide, I will show you some steps to simply tune Configuration Manager performance. These are simple steps, but many of us forget to do this.

Configuration Manager:

Configuration Manager Rebuild Indexes

1. Start your Configuration Manager Console;

2. 가십시오 Administration\Site Configuration\Sites. Select your site and click Settings in the upper menu. Click Site Maintenance;

3. In the list find Rebuild Indexes 그리고 클릭 편집하다;

4. Click Enable this task and set the time and days to run. When complete click 좋아요;

5. Configure ALL OTHER items in the list as you need and click 좋아요;

SQL:

Memory Limit

1. 달리다 SQL Management Studio and connect to your SCCM Instance;

2. 마우스 오른쪽 버튼 click on the instance and click Properties;

3. 을 위한 Memory enter your Minimum server memory (in MB) 그리고 Maximum server memory (in MB). Click 좋아요;

4. 마우스 오른쪽 버튼 click on the instance and click Restart to apply Memory changes;

5. In pop-up windows click 예;

Database File Size limits

1. 마우스 오른쪽 버튼 click on your SCCM database 그리고 클릭 Properties;

2. 을 위한 Files set Initial Size (MB) 그리고 Autogrowth/Maxsize;

3. 을 위한 Options at option Recovery model set Simple (if you set Full – then your logs increase very quickly and eat all disk space). Click 좋아요;

4. Repeat these steps for the SUSDB database and ReportServer database (by default Recovery model – Full);