Agricultural bank head office since 1998 popularized edition of new edition network formally system of information of integrated business statistic, this system is to be based on WindowsNT4.0 platform, use pattern of client ／ server, the large database that builds for the foundation with Microsoft SQL Server uses a program, systematic interface friendly, operation is handy, computation, analysis, retrieve a function very powerful, undertake to make sure agricultural bank system is seasonable fore-and-aft collect with transverse business data, make statistical etc according to diverse demand, undertake analysis of overall business activity provided strong safeguard. But the traversal speed when the promotion that covers a process in this, author in safeguarding discovers the system has is slower, carry an operation in Win95 client especially when particularly serious, afore-mentioned problems after the influence that through eliminating reticle the hardware such as join may bring still are. Author course fumbles carefully, discover the systematic demand to hard, software is higher, design efficiency for sufficient play, achieve optimal run the effect, need system of hard to the computer, software to undertake relatively complete function test and optimal configuration, especially the stand or fall that memory configures has conclusive effect to systematic traversal speed. Below, the author offers a few understanding and view with respect to the memory configuration that how optimizes SQLServer database server.
One, the basic idea of concerned memory
Memory of 1 physics and fictitious memory
WindowsNT uses two kinds of memory: Physical memory and fictitious memory.
Physical memory: Install the memory in computer interior as RAM chip.
Fictitious memory: The disk that is used at function of imitate RAM chip (hard disk) space, it is to pass the partial content that will not use currently in memory to store temporarily character actually on disk, make the system can be used than machine physics memory more memory.
2 divide page and cent page file
The demand that WindowsNT system keeps internally through using disk space to make gets the part alleviates, the technology that uses morer than physical memory memory thereby calls “ to exchange ” or distribute a page, the fictitious memory technology that says normally namely. When normally system of Windows NT 4.0 is installed, will be in conduct the trade that a size sets to be 16MB on driver (cent page) file (Pagefile.sys) .
2, optimize configuration of memory of system of Windows NT 4.0
Below most circumstance, to develop efficiency of system of Windows NT 4.0 adequately, the action of memory has force more compared with the processing capability of processor, falling in environment of mode of client ／ server especially is such more, because fall not to stress the ability of processor very in this kind of environment normally, pay attention to the applied need that whether uses enough memory to satisfy each clients very however instead. In addition, to obtain fault tolerance function and protective application order, assure to apply program high speed to move, function of sufficient play design needs to have enough much memory, especially industrial plot is designed and all sorts of project application processes need to take up many memory will undertake complex calculation more.
Previous12 3 4 Next
Hot Tags: