Install SCCM requirements Part 1 SQL Memory configuration. Before we start SCCM installation we need install and configure all requirements. One of them – SQL Instance “Memory Limits“.

For normal work, you must use next memory size for SCCM SQL:

  • Minimum 8192 for “Primary Site“;
  • Minimum 4096 for “Secondary Site“;

From Microsoft:

A note about SQL Server Memory:

When you use a database server that is co-located with the site server, dedicate 50 percent of the available addressable system memory for SQL Server.

When you use a dedicated SQL Server, dedicate 80 percent of the available addressable system memory for SQL Server.

Configuration Manager requires SQL Server to reserve a minimum of 8 gigabytes (GB) of memory in the buffer pool used by an instance of SQL Server for the central administration site and primary site and a minimum of 4 gigabytes (GB) for the secondary site. This memory is reserved by using the Minimum server memory setting under Server Memory Options and is configured by using SQL Server Management Studio.

In my case I have very weak SQL, so I only show where and how set this limits.

1. Run “Microsoft SQL Server Management Studio“;

2. Connect to your “SCCM Instance”. Enter “Server Name” and click “Connect” button;

3. Right Mouse Button click on the instance and select “Properties“;

4. Go to “Memory” and set “Minimum server memory (in MB)” and “Maximum server memory (in MB)” according information I wrote earlier. Click “OK” button;

5. To apply this changes you must restart instance services, you can do it from “Microsoft SQL Server Management Studio“. Right Mouse Button click on the instance and select “Restart“;

6. Click “Yes” on pop-up windows;

We did it!