No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

FAQ-How to Set the Memory Size of the SQL Server to Improve the Server Performance

Publication Date:  2012-07-24 Views:  48 Downloads:  0
Issue Description
Q:
How to set the memory size of the SQL database to improve the server performance?
Alarm Information
Null
Handling Process
A:
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)
256                                     40
512                                     80
1024                                 160
...............
The rest is on the analogy of this.
Root Cause
Null
Suggestions
This method is applicable to the NM server with poor hardware performance. If the server has good performance, no modification is necessary.

END