SQL Server sp_configure control memory usage

Background knowledge:

sp_configure display or change global configuration settings for the current server (use sp_configure to display or change server-level settings.) )

View global configuration values

Method 1, execute sp_configure; view all directly.

Method 1, execute sp_configure @configname = ' Name ', and view the specified directly.

Method 2, save to the table for easy operation

First step: Build a table

                                 C reate table Instanceconfigure (
                        &NBS P        name nvarchar
                    &NB Sp            minimum int,
                  &N Bsp              maximum int,
                &N Bsp                config_value int,
            &NBS P                    run_value int);
                                  Go

Step Two: Insert data

INSERT INTO Instanceconfigure
Execute sp_configure;
Go

--------------------------------------------------------------------------------------------------------------- --------------------------------------------

Method 1,

min server memory means that after the SQL Server R address space has grown to this value, it will not be less than this value. When you start SQL Server, only the required memory is requested.

Execute sp_configure @configname = ' min server memory (MB) ', @configvalue = 100
Reconfigure with override;
Go

Method 2,

max server memory controls the maximum size of total server memory. also through sp_configure configuration;

Method 3,

Set working set size this is obsolete, and Windows will no longer respect this parameter. also through sp_configure configuration;

Please don't use it.

Method 4,

Lock pages in memory

To view my article:

Http://www.cnblogs.com/JiangLe/p/4008036.html

SQL Server sp_configure control memory usage