Improve Configuration Manager Performance: Rebuild Indexes and SQL Memory and Database Limits. In questa guida, I will show you some steps to simply tune Configuration Manager performance. These are simple steps, but many of us forget to do this.
Gestore di configurazione:
Configuration Manager Rebuild Indexes
1. Start your Configuration Manager Console;
2. Vai a AmministrazioneConfigurazione sitoSiti. Select your site and click Impostazioni nel menu superiore. Clic Site Maintenance;
3. In the list find Rebuild Indexes e clicca Modificare;
4. Clic Enable this task and set the time and days to run. Al termine, fare clic OK;
5. Configure ALL OTHER items in the list as you need and click OK;
SQL:
Memory Limit
- Correre SQL Management Studio and connect to your SCCM Instance;
2. Pulsante destro del mouse click on the instance and click Proprietà;
3. Per Memoria enter your Memoria minima del server (in MB) E Memoria massima del server (in MB). Clic OK;
4. Pulsante destro del mouse click on the instance and click Ricomincia to apply Memory changes;
5. In pop-up windows click SÌ;
Database File Size limits
- Pulsante destro del mouse click on your SCCM database e clicca Proprietà;
2. Per Files impostato Initial Size (MB) E Autogrowth/Maxsize;
3. Per Opzioni at option Recovery model impostato Simple (se imposti Pieno – then your logs increase very quickly and eat all disk space). Clic OK;
4. Repeat these steps for the SUSDB database and ReportServer Banca dati (by default Recovery model – Pieno);