• I agree. Set a max, otherwise you don't know how far SQL Server will go. It tries to take as much as it can, though the OS has the ability to steal it back. That's a relatively slow process, though, so I'd set a max.