We have increased the RAM capacity on the OS to 40G and I have changed the max memory parameter to 36G in SSMS.
When I select "current value", it shows 36G.
However, monitoring memory usage at OS level doesn't show more memory being consumed.
I know that, in theory, it's possible to change the max memory setting while SQL Server is still running, but does it really work? Do I need to restart the server? Or am I being impatient?