Boot.ini

Angelo
Member Posts: 180
Hi Master,
I want to know if I use memory 6GB in my server(2003 enterprise and sql 2000 enterprise), Have I edit Boot.ini file to add "/3GB /PAE" ? and AWE Memory must be "enable"? this modification can make our navision performance better? I'm not system engineer so I blind of this term...pls advice...
thx,
angelo
I want to know if I use memory 6GB in my server(2003 enterprise and sql 2000 enterprise), Have I edit Boot.ini file to add "/3GB /PAE" ? and AWE Memory must be "enable"? this modification can make our navision performance better? I'm not system engineer so I blind of this term...pls advice...
thx,
angelo
0
Comments
-
Check these:
http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx
http://support.microsoft.com/default.aspx?scid=kb;en-us;291988&Product=winsvr2003
http://support.microsoft.com/kb/283037/Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
Who ever done it before?
May I know the performance after done this one?
Pls share.... [-o<
rgds,
angelo0 -
What are your performance issues?
You should investigate your cache contents during the day. If the cache is stable you don't need to expand memory.
Another solution is to "tune" your indexes. If you remove unused indexes SQL will consule less memory0 -
In order for Microsoft SQL Server 2000 Enterprise Edition to use over 4 GB of RAM AWE must be enabled. AWE is a set of application programming interfaces (APIs) to the memory manager functions that enables programs to address more memory than the 4 GB that is available through standard 32-bit addressing. SQL AWE memory is static not dynamic so when the SQL Server service starts it will reserve the memory specified as the “max server memory”. If there is 8 GB of memory on the server you will want to set the “max server memory” to 7 GB to allow 1 GB for the OS. The /PAE switch must also be included in the BOOT.INI file on the OS without /PAE AWE cannot reserve memory in excess of 4 GB. The /3GB switch should not be used in conjunction with AWE, but /3GB can be used in conjunction with /PAE on servers with more than 4 GB of memory but only running SQL Server Standard edition. The OS will need to be rebooted for any BOOT.INI changes to take effect.0
-
I wrote this article once.
Important to know is that you can set all the switches and stuff ... but it's only useful for data caching. When on a 32 bit server, you can put whatever RAM you want, you'll still be limited for plan caching, sort space and lock memory ....
0 -
Thank you very much for your input.....
Now, I have successfully implemented this and it seem better performance
rgds,
Angelo0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions