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