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
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.