Howdy, Stranger!
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
- 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
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
hardware configuration for navision sql option
scott
Member Posts: 76
Does anyone have documentations on this?
the situation:
130 concurrent users
60G database
3.6 Navision
Questions:
1) Can we use windows 2003? What about SQL 2005?
2) I guess 4 CPU is required. What about RAM? I think we need 4G, but SQL 2000 Standard edition can only use 2G. To upgrade to SQL 2000 Enterprise will cost a lot...
3) No of hard drives? I think I should use 2 (RAID1) for OS and SQL. 8 (RAID10) for database. Any other suggestions? Should I add 2 more (RAID 1) for log file?
Thanks.
Scott
the situation:
130 concurrent users
60G database
3.6 Navision
Questions:
1) Can we use windows 2003? What about SQL 2005?
2) I guess 4 CPU is required. What about RAM? I think we need 4G, but SQL 2000 Standard edition can only use 2G. To upgrade to SQL 2000 Enterprise will cost a lot...
3) No of hard drives? I think I should use 2 (RAID1) for OS and SQL. 8 (RAID10) for database. Any other suggestions? Should I add 2 more (RAID 1) for log file?
Thanks.
Scott
0
Comments
Three thing to consider:
HARDWARE
INSTALLATION/CONFIGURATION
MAINTENANCE
HARDWARE
1. CPU
More is better than faster. Remember when using processors with Hyper-Threading both physical and logic processors count toward the O/S and SQL licenses. The total number of processors will effect the software requirements. I
2. Memory
You can never have to much.
3. Disk
Drive 0 (RAID 1)
Install O/S and programs here.
Drive 1 (RAID 1)
Place SQL Log file here. This should be the only file on this drive. If you are running multiple databases, each log file should be placed on a separate RAID 1 drive set.
Drive 2 (RAID 10)
Place the SQL data files here. More drives is better than larger drives. The idea is to get as many heads access the data as possible.
Use caching RAID controllers and turn on both read and write cache. make sure the controllers have battery backup for their cache. MAKE SURE THE CONTROLLERS ARE SUPPORTD WITH SQL. The failure of an unsupported controller can corrupt the database
INSTALLATION/CONFIGURATION
Install only the O/S services required. Do Not do a default install.
MAINTENANCE
Develop and follow a maintence plan. ReIndex on a regular basis and do not rely on autogrow. You can buy the biggest server your budget allows but if you do not build and maintain it properly you will not be happy with the performance.
Hope this is helpful.
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.