Improve Configuration Manager Performance: Rebuild Indexes and SQL Memory and Database Limits. I denne 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. Gå til AdministrationWebstedskonfigurationWebsteder. Select your site and click Indstillinger i den øverste menu. Klik Site Maintenance;
3. In the list find Rebuild Indexes og klik Redigere;
4. Klik Enable this task and set the time and days to run. Når du er færdig, klik Okay;
5. Configure ALL OTHER items in the list as you need and click Okay;
SQL:
Memory Limit
- Løb SQL Management Studio and connect to your SCCM Instance;
2. Højre museknap click on the instance and click Ejendomme;
3. Til Hukommelse enter your Minimum server memory (in MB) og Maximum server memory (in MB). Klik Okay;
4. Højre museknap click on the instance and click Genstart to apply Memory changes;
5. In pop-up windows click Ja;
Database File Size limits
- Højre museknap click on your SCCM database og klik Ejendomme;
2. Til Files sæt Initial Size (MB) og Autogrowth/Maxsize;
3. Til Muligheder at option Recovery model sæt Simple (if you set Full – then your logs increase very quickly and eat all disk space). Klik Okay;
4. Repeat these steps for the SUSDB database and ReportServer database (by default Recovery model – Full);