Under heavy Load, my SQL Server database is executing queries really slowly. 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. I'm wondering 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) *max server memory* is set to the default. It's a web garden for one site. My database is 2 GB. I thought SQL Server would use more memory under a heavy load with more RAM, scaling up for the number of users/queries. [![enter image description here][1]][1] [![enter image description here][2]][2] [1]: https://i.sstatic.net/YDyJ3.png [2]: https://i.sstatic.net/9H59n.png