• It was my understanding that SQL only acquired RAM when it needed it. That is, it doesn't automatically grab the max ram as soon as it starts. Of course SQL can find a lot of reasons to grab ram, so it seems as if it always gets the max, but I think you can give SQL possible access to extra ram and have it not use it.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.