Home Forums SQL Server 2005 Administering Basic Memory Question - > 2147483647 2g limit? Or.is it even enabled? RE: Basic Memory Question - > 2147483647 2g limit? Or.is it even enabled?

  • It is important to set the maximum memory limit for 64-bit SQL Server. The memory reported as available to SQL Server includes the page file size, so if you have a page file then SQL Server will try to use it as part of its memory pool. You are then looking at what should be memory to memory transfers being disk to memory, which will badly hurt your performance.

    When deciding how much memory to allocate to SQL Server, you must first take out what is needed by Windows, Anti-Virus, file cache, and other components that are always running. You can divide the rest up between your SQL instances. If they are all of the same importance, give them all the same memory. Otherwise give the most important instances the most memory.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara