Do you know to never give SQL Server all your RAM?
22/11/2010 7:07 PM by
Microsoft SQL Server is made to use all the available memory in a server for itself. It will eat all the memory you throw at it. This can be a problem because your other applications may suffer performance problems as all the system memory is gone. To limit this behaviour you can limit the maximum amount of memory SQL is allowed to use.
Do you feel this rule needs an update?