nevilc
Contributor
Contributor

Memory assigned issue

Good Morning

need assistance with memory assignment, we have Server 2012 R2 running on a host that had initially had 12 GB (12675072 KB) of RAM and than was extended to 32 GB (33554432 KB) even the OS shows 32 GB or RAM but the granted size still shows 12 GB as a result consumed RAM is 11 GB and the program that we using SQL cannot run more RAM. what can i do to have this host granted RAM of 32 GB.

HostRAM2.JPG HostRAM1.JPG

Tags (1)
2 Replies
connector1
Contributor
Contributor

Maybe it's limited in MSSQL.   Look at this:

Server Memory Server Configuration Options - SQL Server | Microsoft Docs

birend1988
Hot Shot
Hot Shot

You can configure the memory reservation to the server so that SQL will use all 32 GB.

VCIX, NCAP
0 Kudos