Improve Configuration Manager Performance: Rebuild Indexes and SQL Memory and Database Limits. I den här guiden, I will show you some steps to simply tune Configuration Manager performance. These are simple steps, but many of us forget to do this.
Konfigurationshanteraren:
Configuration Manager Rebuild Indexes
1. Start your Configuration Manager Console;
2. Gå till AdministrationWebbplatskonfigurationWebbplatser. Select your site and click inställningar i den övre menyn. Klick Site Maintenance;
3. In the list find Rebuild Indexes och klicka Redigera;
4. Klick Enable this task and set the time and days to run. När du är klar klicka OK;
5. Konfigurera ALL OTHER items in the list as you need and click OK;
SQL:
Memory Limit
- Springa SQL Management Studio and connect to your SCCM Instance;
2. Höger musknapp click on the instance and click Egenskaper;
3. För Minne enter your Minimum server memory (in MB) och Maximum server memory (in MB). Klick OK;
4. Höger musknapp click on the instance and click Omstart to apply Memory changes;
5. In pop-up windows click Ja;
Database File Size limits
- Höger musknapp click on your SCCM database och klicka Egenskaper;
2. För Files uppsättning Initial Size (MB) och Autogrowth/Maxsize;
3. För Options at option Recovery model uppsättning Simple (if you set Full – then your logs increase very quickly and eat all disk space). Klick OK;
4. Repeat these steps for the SUSDB database and ReportServer databas (by default Recovery model – Full);