Advertisements
BTNHD News

SCCM 2012 R2 SQL Server Memory Configuration

sccm_wp_header This year I'm focusing on SCCM 2012 R2 and building the lab as if I was managing 100,000 clients. During the SQL Server configuration part, you have to configure the limitation of the memory. Now, depending on your memory configuration and server setup, you may want to do this because during the installation of System Center Configuration Manager 2012 R2 you will get the following SQL Server memory warnings:

Screen shot 2014-12-25 at 11.01.06 PMThe configuration manager requires SQL Server to reserve a minimum of 8GBs of memory for the Central Administration Site and for the Primary Site. This memory is reserved by using the minimum server memory setting under Server Memory Options and is configured by using SQL Server Management Studios. If your SQL Server is already configured for un-limited memory usage you should configure SQL Server memory to have a maximum limit. On my virtual machine, I did the recommendation of 8GBs:

SQL Memory Image

 

Advertisements
About BjTechNews (867 Articles)
An IT guy trying to learn everything about technology and sharing it with you all. I'm a blogger and video blogger who highlights daily news in the tech industry, promoting tips and hacks for fellow techies.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s