Sql-server – SQL Server : not allocating all memory that it has on disposal

sql server

Yesterday, we moved from dedicated server to amazon AWS. And since then we see strange thing. Our SQL Server is not using more than 2.8GB of RAM, which is strange because on old server it always load everything to RAM. Our database is 289GB large, we have so many indexes etc. We are running on Microsoft SQL Server Standard edition, which should give us access to 128GB RAM for database usage.

What could it be the reason? Anyone experienced similar issue? Beside this, database seems to be working fine at the moment, although it had issue 1 time during 24 hours where it became completely unresponsive, so we restarted the SQL Server at that time. But something is strange, something is not right, because that ram should be filled to maximum as it always does.

Best Answer

Check the following counters:

select object_name,counter_name,instance_name,cntr_value/1024/1024 [GB] 
from sys.dm_os_performance_counters 
where counter_name like 'T%Server%'

Total Server memory - current consumption

Target Server memory - intention to consume next

Related Question