SQL Server is designed to utilize as much memory as the system it is running on has available. While this is fine for systems that are dedicated to running only SQL Server it can cause performance issues with systems that need to run other applications. MANEX recommends that a dedicated server is used to run a SQL Server system.

If it is not possible to have a dedicated SQL system then SQL Server allows users to change the Server Memory Configurations. This allows users to modify their SQL Server to use only as much memory as wanted leaving enough for any other tasks that may need to be performed. Again, MANEX recommends having a dedicated SQL system, as changing the Memory Configurations could cause performance issues.

For more information about SQL Server memory settings and how to set up SQL Server memory configuration please visit: Server Memory Server Configuration Options.