Until now I was able to find all my questions already asked and answered, but not today.
I have a SQL 2008R2 Std running on virtual Win 2008R2 Enterprise. The server used to have 11GB of RAM, 8 dedicated to SQL.
I have got more memory for that server - a total of 18GB and I have increased "max server memory" to 14GB.
But the SQL does not take more than 11GB.
Total cached memory(MB) 10819.0859375
Total SQL Server Memory (MB) 11000.0000000
Total physical memory MB 18431.0000000
Available Physical Memory MB 5134.0000000
I have tried the next:
1. decrease Total SQL Server Memory to 6GB and increase it back to 14GB
2. set Total SQL Server Memor to unlimited (2147483647)