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.

Configuratiemanager:

Configuration Manager Rebuild Indexes

1. Start your Configuration Manager Console;

2. Gaan naar Administration\Site Configuration\Sites. Select your site and click Instellingen in the upper menu. Klik Site Maintenance;

3. In the list find Rebuild Indexes en klik Edit;

4. Klik Enable this task and set the time and days to run. When complete click OK;

5. Configureer ALL OTHER items in the list as you need and click OK;

Sql:

Memory Limit

1. Loop SQL Management Studio and connect to your SCCM Instance;

2. Rechtermuisknop click on the instance and click Eigenschappen;

3. Voor Memory enter your Minimum server memory (in MB) En Maximum server memory (in MB). Klik OK;

4. Rechtermuisknop click on the instance and click Restart to apply Memory changes;

5. In pop-up windows click Yes;

Database File Size limits

1. Rechtermuisknop click on your SCCM database en klik Eigenschappen;

2. Voor Files set Initial Size (MB) En Autogrowth/Maxsize;

3. Voor Options at option Recovery model set Simple (if you set Full – then your logs increase very quickly and eat all disk space). Klik OK;

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