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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 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
Hardware Sizing for 5 years
MLoacher
Member Posts: 8
Hello everybody,
In my company we are using NAV 2009 for 2 years now. Today the database has a size of 400GB. We have about 380 Users working on the system currently.
Next year we would like to upgrade to a newer version. For this we would like to buy new more powerful server. At least one new server for the SQL Database and one Server for the Service Tier.
I would like to calculate this for at least 5 years. So we will have a 1000GB database.
I thought about something like this:
SQL:
Intel® Xeon® E5-4600
RAM 1TB
HDD 4TB
Ethernet 2 x Intel QuickPath Interconnect (QPI): 6,4 GT/s; 7,2 GT/s; 8,0 GT/s
ServiceTier:
Intel® Xeon® processor E5 2600 v4
RAM 32gb
HDD 500GB
Ethernet 2 x 10Gb
What do you think about it? Is it too much or too low? Is there a guideline how to calculate such things?
best regards
Max
In my company we are using NAV 2009 for 2 years now. Today the database has a size of 400GB. We have about 380 Users working on the system currently.
Next year we would like to upgrade to a newer version. For this we would like to buy new more powerful server. At least one new server for the SQL Database and one Server for the Service Tier.
I would like to calculate this for at least 5 years. So we will have a 1000GB database.
I thought about something like this:
SQL:
Intel® Xeon® E5-4600
RAM 1TB
HDD 4TB
Ethernet 2 x Intel QuickPath Interconnect (QPI): 6,4 GT/s; 7,2 GT/s; 8,0 GT/s
ServiceTier:
Intel® Xeon® processor E5 2600 v4
RAM 32gb
HDD 500GB
Ethernet 2 x 10Gb
What do you think about it? Is it too much or too low? Is there a guideline how to calculate such things?
best regards
Max
0
Answers
https://msdn.microsoft.com/en-us/library/dd301054(v=nav.90).aspx#NavServerReqs
https://msdn.microsoft.com/en-us/library/dd301054(v=nav.90).aspx#SQLReq
http://www.1clickfactory.com/media/619832/microsoftdynamicsnav2013r2singletenantonpremisesizingguidelines.pdf
i suggest at least 64gb ram, 1T hdd for the nav service tier server. before upgrading check, if you really want to upgrade all historic data. better only upgrade only needed data and use the old database as readonly archive.
Franz Kalchmair, MVP
Alias: Jonathan Archer
please like / agree / verify my answer, if it was helpful for you. thx.
Blog: http://moxie4nav.wordpress.com/
Remember if you upgrade the I/O of the SQL server will drop by 50% and if you have a lot of dimensions the database size will also decrease.
You cannot size these things without knowing which parts of Navision are used and which mods are in place.
If you have a good budget, consider also virtualization so you can install Nav services SQL server and webserver on different servers.