Improve Configuration Manager Performance: Rebuild Indexes and SQL Memory and Database Limits. 在本指南中, I will show you some steps to simply tune Configuration Manager performance. These are simple steps, but many of us forget to do this.
配置管理器:
Configuration Manager Rebuild Indexes
1. Start your Configuration Manager Console;
2. 去 管理站点配置站点. Select your site and click 设置 在上方菜单中. 点击 Site Maintenance;
3. In the list find Rebuild Indexes 然后单击 编辑;
4. 点击 Enable this task and set the time and days to run. When complete click 好的;
5. 配置 ALL OTHER items in the list as you need and click 好的;
SQL:
Memory Limit
- 跑步 SQL管理工作室 and connect to your SCCM Instance;
2. 鼠标右键 click on the instance and click 特性;
3. 为了 记忆 enter your 最小服务器内存 (单位:MB) 和 最大服务器内存 (单位:MB). 点击 好的;
4. 鼠标右键 click on the instance and click 重新开始 to apply Memory changes;
5. In pop-up windows click 是的;
Database File Size limits
- 鼠标右键 click on your SCCM database 然后单击 特性;
2. 为了 Files 放 Initial Size (MB) 和 Autogrowth/Maxsize;
3. 为了 Options at option Recovery model 放 Simple (if you set 满的 – then your logs increase very quickly and eat all disk space). 点击 好的;
4. Repeat these steps for the 南方数据库 database and ReportServer database (by default Recovery model – 满的);