Improve Configuration Manager Performance: Rebuild Indexes and SQL Memory and Database Limits. V tem priročniku, I will show you some steps to simply tune Configuration Manager performance. These are simple steps, but many of us forget to do this.
Upravitelj konfiguracije:
Configuration Manager Rebuild Indexes
1. Start your Configuration Manager Console;
2. Pojdi do AdministracijaKonfiguracija mestaSpletna mesta. Select your site and click nastavitve v zgornjem meniju. Kliknite Site Maintenance;
3. In the list find Rebuild Indexes in kliknite Uredi;
4. Kliknite Enable this task and set the time and days to run. When complete click v redu;
5. Configure ALL OTHER items in the list as you need and click v redu;
SQL:
Memory Limit
- Teči SQL Management Studio and connect to your SCCM Instance;
2. Desni gumb miške click on the instance and click Lastnosti;
3. Za Spomin enter your Najmanjši pomnilnik strežnika (v MB) in Največji pomnilnik strežnika (v MB). Kliknite v redu;
4. Desni gumb miške click on the instance and click Ponovni zagon to apply Memory changes;
5. In pop-up windows click ja;
Database File Size limits
- Desni gumb miške click on your SCCM database in kliknite Lastnosti;
2. Za Files set Initial Size (MB) in Autogrowth/Maxsize;
3. Za Options at option Recovery model set Simple (if you set Full – then your logs increase very quickly and eat all disk space). Kliknite v redu;
4. Repeat these steps for the SUSDB database and ReportServer database (by default Recovery model – Full);