6 Hits total
text Language
23.695 Author

sql server memory

This is a quick overview of some features

  1. You can establish upper and lower limits for how much memory (buffer pool) is used by the SQL Server database engine with the min server memory and max server memory configuration options. Before you set the min server memory and max server memory options, review the references in the section titled "Memory" in the following Microsoft Knowledge Base article:
  2. 319942 How to determine proper SQL Server configuration settings
  3. Notice that the max server memory option only limits the size of the SQL Server buffer pool. The max server memory option does not limit a remaining unreserved memory area that SQL Server leaves for allocations of other components such as extended stored procedures, COM objects, non-shared DLLs, EXEs, and MAPI components. Because of the previous allocations, it is typical for the SQL Server private bytes to exceed the max server memory configuration. For more information about allocations from this unreserved memory area, click the following article number to view the article in the Microsoft Knowledge Base:
  4. 316749 There may not be enough virtual memory when you have a large number of databases in SQL Server
Parsed in 0.003 seconds