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“;
“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“;