Note This article also applies to Microsoft SQL Server 2014. Please review the changes that are described here before you upgrade to SQL Server 2012 or before you configure a new installation of SQL Server 2012. Microsoft SQL Server 2012 introduces changes in memory manager that affect how administrators configure these memory options.
Sp_configure options (max server memory (MB), min server memory (MB), and awe enabled) The different configuration options include the following: SQL Server also offers memory-related configuration options to aid fine tuning for specific application behavior patterns and specific advanced requirements.
Microsoft SQL Server performs automatic and dynamic memory management based on the current memory requirements of the internal SQL Server components and workload on the system. SQL Server 2012 Enterprise SQL Server 2014 Enterprise SQL Server 2014 Enterprise More.
0 kommentar(er)
