Improve Configuration Manager Performance: Rebuild Indexes and SQL Memory and Database Limits. In deze gids, 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. Ga naar BeheerSiteconfiguratieSites. Select your site and click Instellingen in het bovenste menu. Klik Site Maintenance;
3. In the list find Rebuild Indexes en klik Bewerking;
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
- Loop SQL Management Studio and connect to your SCCM Instance;
2. Rechter muis knop 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. Rechter muis knop click on the instance and click Herstarten to apply Memory changes;
5. In pop-up windows click Ja;
Database File Size limits
- Rechter muis knop klik op uw 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);