Position:Home>Database Development> Optimize the strategy that memory of SQLServer database server configures
Optimize the strategy that memory of SQLServer database server configures
From;  Author:Stand originally


Physical memory (the advantage clearly with convenient and fast RAM) , but because its price is high, accomplish impossibly also thed more the better, because this is passed reasonable optimize memory configuration, augment fictitious memory raised computer operation speed to also become a very important applied technology step.

1  makes sure Windows NT system is basic memory demand

System of Windows NT 4.0 configures 12MB memory to Xiaoying, 16MB memory is used basically quite, it is OK to make sure NT system has 32MB memory below normal circumstance, because not be all 16MB,main memory is used at the same time in any moment. If add a few services and applied program, the demand that keeps internally can increase quickly. Be like:

(1) adds a network to serve space of need 4MB memory;

(Function of 2) fault tolerance and memory of 8MB of need of systematic protection function (if disk mirror is mixed,divide a functional) ;

(3) undertakes graphical picture handles need to add 16MB memory space;

(4) installation VC, VB develops a system to need to add 16MB memory space;

Additional, if on Windows NT compose builds large database to wait like Sybase, Microsoft SQL Server, the demand that keeps internally is more.

2  optimize memory function

The time that takes up to make WindowsNT unapt more memory perhaps wastes processor overly is used at form feed, can use the following method to optimize memory function.

(1) reduces the amount of indication color;

(2) drops indication resolution;

(3) is not used as far as possible or use the wall paper with a lesser width;

(4) shuts the service order that does not need or driver, do not use other application program on the server as far as possible.

Out of service serves or the operation move of driver is as follows:

① needs the name of the service of out of service or driver certainly;

② doubleclicks “ to serve ” or icon of “ equipment ” from inside ” of “ Control Panel;

③ chooses to want the name of the service of out of service or equipment driver in list, click “ to stop ” pushbutton, appear at this moment affirm operation dialog box;

④ choice “ is ” affirms an operation, shut a dialog box to finish a setting next.

3  optimize fictitious memory

The need when undertaking installing to Windows NT fictitious memory is reasonable and affirmatory the ” of “ initial volume of files of each driver cent page and “ maximum ” two parameter, they are used at appointing the initiative space of minute of page file and the largest space. To this two parameter make a few explanations below:

Initial volume: Point to initiative the file size when founding file of this minutes of page, the unit is MB, according to default setting, this value is installed to be the size of the physical memory in the system.
Previous 1 23 4 Next