Skip to main content
2 of 4
deleted 1 character in body

Sql Server 2012 doesn't use enough memory

Under Heavy Load, my sql server database is executing queries really slow. I have 96 GB of ram and my CPU is high(100%) but my physical memory usage is at 9%. I looked at the sql server memory usage which is in the screenshots below. I enabled Locked In Pages but it didn't seem to help. Im wonder if there is anything i can do in sql server to utilize more memory.

Version: SQL SERVER 2012 Web Edition SP3 (x64) OS: Windows Server 2012 R2 (x64)

enter image description here

enter image description here