Improve Менеджер конфігурації Performance: Rebuild Indexes and SQL Memory and Database Limits. In this guide, I will show you some steps to simply tune Менеджер конфігурації performance. These are simple steps, but many of us forget to do this.
Менеджер конфігурації:
Configuration Manager Rebuild Indexes
1. Start your Configuration Manager Console;
2. Go to Administration\Site Configuration\Sites. Select your site and click Налаштування in the upper menu. Натисніть Site Maintenance;
3. In the list find Rebuild Indexes і натисніть Edit;
4. Натисніть Enable this task and set the time and days to run. When complete click добре;
5. Configure ALL OTHER items in the list as you need and click добре;
SQL:
Memory Limit
- бігти SQL Management Studio and connect to your SCCM Instance;
2. Права кнопка миші click on the instance and click Properties;
3. для Memory enter your Minimum server memory (in MB) і Maximum server memory (in MB). Натисніть добре;
4. Права кнопка миші click on the instance and click Restart to apply Memory changes;
5. In pop-up windows натисніть Yes;
Database File Size limits
- Права кнопка миші click on your SCCM database і натисніть Properties;
2. для Files set Initial Size (MB) і Autogrowth/Maxsize;
3. для Options at option Recovery model set Simple (if you set Full – then your logs increase very quickly and eat all disk space). Натисніть добре;
4. Repeat these steps for the SUSDB database and ReportServer database (by default Recovery model – Full);