Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones All the memory RE: All the memory
Steve Jones - SSC Editor
SSC Guru
Points: 734449
More actions
June 19, 2018 at 2:45 am
#1994400
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.