Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 269 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Couple of questions concerning SQL 2005 server setup
BGI
Member Posts: 176
We do a lot of sql installs, and always have some discussions on some settings when installing a sql server, so why not throw it into this group and see what the opinions are:
1) collation sequence of sql server: Needs to be Case Sensetive and accent sensetive, otherwise possible problems with tempdb? (collating sequence of Navision db needs to be always cs and as)
2) 32 bit server with 6 gb of memory:
- do you need to set de /3GB switch?
- do you need to set up sql to use AWE memory
3) are these settings the same for a 64 bit server?
1) collation sequence of sql server: Needs to be Case Sensetive and accent sensetive, otherwise possible problems with tempdb? (collating sequence of Navision db needs to be always cs and as)
2) 32 bit server with 6 gb of memory:
- do you need to set de /3GB switch?
- do you need to set up sql to use AWE memory
3) are these settings the same for a 64 bit server?
Rgds
Benny Giebens
Benny Giebens
0
Comments
ad 2) You need /3GB switch if you are using 2-16 GB of RAM. If you are using more than 16GB, the switch is not needed (is contraproductive). Do not forget that you need to use /PAE if you are using more than 4GB RAM. If you want to use more than 4GB for SQL, you need to set AWE.
ad 3) for AWE on 64bit see http://blogs.msdn.com/slavao/archive/20 ... 93019.aspx. /3GB and /PAE are not used on 64bit.
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
-Forget 32bit for SQL2005. Best move directly to 64bit. Better performance, easier to add more memory without having to change switches.
-tempDB: best put it on its own RAID1.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
To paraphrase kriki "Why on earth would you use 32 bit"? ](*,) ](*,) ](*,)
64 bit can address 18 billion Gb RAM directly.
/3GB
Furthermore, when you have 4Gb in your server, by default, Windos is going to address 2Gb for OS (kernel mode) and 2Gb for application mode. That's why, by default, you'll only have 2Gb for your SQL Server. With /3Gb, you're going to make 3Gb available for applications (thus SQL Server) and 1Gb for the OS.
/PAE
To be able to map to more then 4Gb RAM, you're going to have to set the /PAE switch. It's somewhat like "HIGHMEM" in the old dos days. You're going to use the lower memory to address the higher memory.
Don't forget to switch the AWE on the SQL Server.
Indeed, when going above 16gb, you'll need to remove the /3Gb switch. It's some kind of counterpoint. With /3GB you only addressed 1GB for the OS. This is not enough to map all the "upper memory" through /PAE.
Hope this makes some sense...
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog