Shulou(Shulou.com)05/31 Report--

This article introduces how to configure memory on the SQLserver server, the content is very detailed, interested friends can refer to, hope to be helpful to you.

How to configure the memory of SQLserver server

1. Turn on the large memory support (windows) in the system:

To enable Windows2000AdvancedServer or Windows2000DatacenterServer support, greater than the physical memory of 4GB, you must add the parameter / pae to the boot.ini file.

The following is the referenced content:

[bootloader]

Timeout=0

Default=multi (0) disk (0) rdisk (0) partition (1) WINNT

[operatingsystems]

Multi (0) disk (0) rdisk (0) partition (1) WINNT= "MicrosoftWindows2000AdvancedServer"

/ fastdetect

Change to:

The following is the referenced content:

[bootloader]

Timeout=0

Default=multi (0) disk (0) rdisk (0) partition (1) WINNT

[operatingsystems]

Multi (0) disk (0) rdisk (0) partition (1) WINNT= "MicrosoftWindows2000AdvancedServer"

/ fastdetect/pae

After this is changed, the system will be restarted.

How to configure the memory of SQLserver server

two。 Enable the lock memory page option (Windows):

1. Enable the lock memory page option

2. On the start menu, click the run submenu, and then type gpedit.msc in the Open box.

On the Group Policy console, expand computer configuration, and then expand Windows Settings.

Expand Security Settings, and then expand Local policies.

5. Select the user Rights assignment check box.

6. The policy appears in the details pane.

In the details pane, double-click Lock memory Page.

8. In the Local Security Policy Settings dialog box, click the add button.

9. In the Select user or Group dialog box, add an account that has the right to run sqlservr.exe.

3. Enable AWE for SQL:

To enable AWE, set aweenabled to 1. Unless a value of maxservermemory is specified, no

Then SQLServer retains almost all available memory, leaving only 128MB or less.

If this option is successfully enabled, when the SQLServer2000 instance is started, the SQLServer error log will

The message "address window extension enabled" appears.

Aweenabled is an advanced option. If you are using sp_configure system stored procedures to change this setting, only

Aweenabled can be changed only when showadvancedoptions is set to 1.

Code is as follows. Set SQL to use 6GB's memory:

The following is the referenced content:

Sp_configureshowadvancedoptions,1

RECONFIGURE

GO

Sp_configureaweenabled,1

RECONFIGURE

GO

Sp_configuremaxservermemory,6144

RECONFIGURE

GO

You must restart the SQLServer2000 instance for the changes to take effect:

Netstopmssqlserver

Netstartmssqlserver

On how to configure the memory of the SQLserver server to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.