This is a weird and obvious problem with the SQL server always as more you feed the memory the more its become hungry.
So avoiding this high memory utilization you need to limit the memory assignment to the SQL process. How to: Set a Fixed Amount of Memory (SQL Server Management Studio)
Hi,
How many memory should be assigned to SQL server ?
Thanks
depends on how many transaction is happening in your infra. if its a small infra like 100>500 vms then you can go for 8GIG of memory limit.will be quite enough
These values runs on MB. 8192 MB > 8 GIG and 14500 MB > 14 GIG.
Thats the reason. change it to 4096 Min and 8192 Max and see the changes
Hi,
I have a question, currently 14GB is max memory and using. If drop max memory to 8GB, will memory not enough for SQL ?
Otherwise, although max is set to 14GB but why all are using ?
Thanks
This is the SQL nature thats why people use to limit this. We seen so many case where 128 Gig of ram assigned and sql using 110 Gig out of it. And not enough transaction even going on.
8 GIG of Memory is enough if you are running till 1000 vm in your infra. so no crisis if you meet the configuration.
Hi,
OK. Do I need to stop vCenter or SQL server before this configuration ? Need restart after configuration ?
Or just configure it ?
Thanks
Just configure it. After configuring its start lowering the memory usage itself. no need of service start/stop.
From my understanding, SQL Server needs to be restarted (after changing memory configurations) so that it releases the additional memory acquired.
SQL Server memory setting. Restart required?
Thanks