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


Maximum: Point out the largest size of file of this minutes of page, the unit is MB.

(1) divides the setting principle of page file:

Initial volume should withhold document of ① cent page default setting, do not want to alter please usually;

The largest size of ideal of file of ② cent page is dimension of systematic physics memory 2.5 times to 4 times. Those who need a specification is: If a large number of memory do not need when systematic work, choose to approach the value of floor level please, use the 2.5 times serves as this dimension initial cost of systematic physics memory namely; If a large number of memory need when systematic work, choose to approach the value of upper limit please.

(2)Windows NT fictitious memory installs measure:

① doubleclicks icon of “ system ” from inside ” of “ Control Panel;

② clicks label of “ function ” in dialog box of ” of “ system character;

③ clicks “ to change ” pushbutton in fictitious memory dialog box, appear at this moment dialog box of ” of “ fictitious memory, the driver casing one by one that carries on listed the size of file of Windows NT all page;

④ is in driver list, the drive that the choice needs to set the file that distribute a page dish accord with, listed in dialog box of ” of size of file of “ driver page ” of “ initial volume and “ maximum ” two parameter column, write the numerical value that determines according to the principle above;

⑤ clicks “ to install ” to affirm above is operated, next ordinal click “ to decide ” pushbutton exits each dialog boxes, the setting that finish.

(98 fictitious memory install 3)Win95 / .

Method of setting of 98 fictitious memory, measure mixes Win95 / the setting of principle and Windows NT 4.0 is roughly same, consult please above the setting of Windows NT.

4  note

(1) is reasonable and affirmatory the maximum of the file that distribute a page, undertake adjustment at any time according to systematic demand, had used much more fictitious memory to will bring about what whole system handles function drop. The goal that sets fictitious memory maximum is to make the user need not be in the exchange of WindowsNT wastes overmuch disk space on the file, after if exceeded the optimal value that the system needs,normally the circumstance falls, the disk vacuum that makes commutative file was wasted.

(2) establishs special hard disk to configure memory exchange area as far as possible, or trade the space is put advocate another partition of hard disk, answer at the same time will advocate the commutative file volume of hard disk falls to 16MB, such advocate hard disk (divisional) use only place operating system and applied order, can reduce commutative number, prevent frequent exchange to expend many CPU time.
Previous 1 2 34 Next