![]() Use min server memory (MB) to guarantee a minimum amount of memory available to the SQL Server Memory Manager. For more information, see Memory Limits for Windows and Windows Server Releases. Memory can be configured up to the process virtual address space limit in all SQL Server editions. This difference is the maximum amount of memory you can assign to the current SQL Server instance. Before you set the amount of memory for SQL Server, determine the appropriate memory setting by subtracting, from the total physical memory, the memory required for the operating system (OS), memory allocations not controlled by the max server memory (MB) setting, and any other instances of SQL Server (and other system uses, if the server is home to other applications that consume memory, including other instances of SQL Server). However, you can set the memory options manually and restrict the amount of memory that SQL Server can access. 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 and EXEs. The max server memory option only limits the size of the SQL Server buffer pool.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |