I'm looking for a good debate on why not to go with a fixed memory setting...my background is from Sybase and Oracle, which both use a fixed memory size.
We have a dedicated SQL server box with 4 GB of ram. The only thing running on the box is SQL Server.
I would like to run with a fixed memory size of 3.5 GB, leaving 500 MB for OS, terminal services, etc.
Seems like all the books recomend letting SQL Server manage the memory dynamically.
I would think that a fixed memory size would take away all the overhead of dynamically allocating/deallocating memeory.
Thoughts, ideas, experiences...
Thanks in advance.