jeudi 4 décembre 2014

SQL Server 2012 Stanadart Edition eating more than 64GB of memory, why and how?


I put SQL Server 2012 Standart on a virtual machine (VMWare) which has roughly 98GB of Memory. Now I checked using taskmanager how much memory is taken by SQL Server 2012.



Microsoft SQL Server 2012 - 11.0.5058.0 (X64)


And see that he ate already 81GB of the memory. I set the max Memory to ~90GB.


SQL Server 2012 Standart should support only 64GB of memory.


Why does my SQL Server eat more than he can? Or is the info incorrect? Any idea? Is that related to a virtual machine using virtual memory? I don't know if balloon driver is activated on VM Host...


If you need any more info I will add it.





Aucun commentaire:

Enregistrer un commentaire