What is the Maximum amount of Memory I should configure SQL to use for a SCCM Site Database Server?
To avoid potential performance problems, you have to configure SQL to use the correct maximum amount of memory depending on where your ConfigMgr Site Database will be located as detailed in this FAQ.
This content is restricted to subscribers