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.
Konfigurācijas pārvaldnieks:
Configuration Manager Rebuild Indexes
1. Start your Configuration Manager Console;
2. Iet uz AdministrācijaVietnes konfigurācijaVietnes. Select your site and click Iestatījumi in the upper menu. Klikšķis Site Maintenance;
3. In the list find Rebuild Indexes un noklikšķiniet Edit;
4. Klikšķis Enable this task and set the time and days to run. When complete click labi;
5. Configure ALL OTHER items in the list as you need and click labi;
SQL:
Memory Limit
- Skrien SQL Management Studio and connect to your SCCM Instance;
2. Right Mouse Button click on the instance and click Īpašības;
3. For Memory enter your Minimum server memory (in MB) un Maximum server memory (in MB). Klikšķis labi;
4. Right Mouse Button click on the instance and click Restartēt to apply Memory changes;
5. In pop-up windows click Yes;
Database File Size limits
- Right Mouse Button click on your SCCM database un noklikšķiniet Īpašības;
2. For Files set Initial Size (MB) un Autogrowth/Maxsize;
3. For Options at option Recovery model set Simple (if you set Full – then your logs increase very quickly and eat all disk space). Klikšķis labi;
4. Repeat these steps for the SUSDB database and ReportServer database (by default Recovery model – Full);