I have an SQL Server Installation which suffers very bad performance due to lack of memory (queries runnig very slow, RESOURCE_SEMAPHORE…). The memory usage never goes above ~4.1 GB, although the machine has 16 GB of physical memory and only 44% is used.
Resource Monitor shows a working set of 4,289,000 KB for sqlservr.exe.
I'm wondering where this limitation is coming from, although we increased "maximum server memory" to 10 GB.
Both Os and DB Server are 64-bit and the editions used have much higher limitations than 4 GB.
I've used sysinternals TestLimit to see if there is a general memory limitation for processes, but a testprocess could use more memory, so it seems to be related to SQL Server itsself.
Any help is appreciated!
OS: Windows Server 2012 R2 Standard 64-bit
SQL Server: SQL Server Standard 64-bit, Version 11.0.5058.0
Server is virtualized on VMWare ESXi 5.1.0
Best Answer
Short update: I could solve the problem myself. Problem was actually not related to the memory. We had high traffic with many very CPU expensive queries which created a constantly high CPU load, which were the reasons for RESOURCE_SEMAPHOREs.
After reducing the quantitiy of queries significantly and tuning the queries itself to be less expensive, the load decreased and there were no more RESOURCE_SEMAPHOREs.
Memory usage is still only 4 GB, but obviously system doesn't need to use more!