I configure SQL Server 2008 to run with fixed memory size 512MB. I restart the server, and "running values" show 512MB.
Then I open Process Monitor, and SQL Server process is using ~1.5GB virtual memory - see the screenshot. I wonder, where's 512MB in this picture?
If I change the memory values from 512 to some other number, the above numbers don't change. The same is in SQL Server 2000, with the only difference being 1.7GB instead of 1.5. So I wonder, what exactly does the specified memory number affect, and where the result of specifying the memory can be seen?