How to set the memory size of the SQL database to improve the server performance?
1. Choose Procedure>Microsoft SQL Server>Enterprise Manager in the Start menu.
2. The SQL Server Enterprise Manager window is displayed.
3. Select current computer under SQL Server Group, right-click and select Property, and the SQL Server Property dialog box is displayed. Click Memory, click Use Fixed Memory Size (MB), drag the glide bar and select certain memory size. The advised values are shown in the following table (instruction part). Click OK to complete the configuration of memory use. After the configuration is complete, it is required to restart the database server to make the modification effective.
Memory Size of Current Computer (MB) Fixed Memory Size Allocated to Database (MB)
The rest is on the analogy of this.
This method is applicable to the NM server with poor hardware performance. If the server has good performance, no modification is necessary.