Nav 2018 physical server - Memory and CPU

TModest
Member Posts: 6
Hi guys,
So i know that there is an existing formula to calculate the memory and CPU for a new server that will have a new Navision 2018 installation and SQL.
So my main question is how to achieve the exact memory and CPU required for a new implementation on a physical server.
*About 100 users will be available in that nav instalation. EDIT
Thanks.
So i know that there is an existing formula to calculate the memory and CPU for a new server that will have a new Navision 2018 installation and SQL.
So my main question is how to achieve the exact memory and CPU required for a new implementation on a physical server.
*About 100 users will be available in that nav instalation. EDIT
Thanks.
0
Best Answer
-
There is no server sizing guidelines document for newer NAV versions as far as I know. The most 'recent' one published by Microsoft was for NAV 2013. You can try googling it and use recommendations described in there as a starting point.
Having said that - it is enough to have one nasty report run to blow up memory requirements for the NST server. The hardware is relatively cheap comparing to software licenses so rather than trying to find 'exact memory' buy as much as you can afford.
SQL sizing-wise the max memory is dictated either by the SQL Server version, or by projected sizes of all (active) databases hosted on that box size. SQL Server will not use more that necessary to keep in memory all the database hosted on it, so if you plan only one NAV database on the server, which will grow to, say 40+GB in a few years time, there is a very little sense buying more that 48 - 64 GB of RAM for such server
CPU wise it is a bit more complicated. Look what else will run run on your server, if you will have any other software on it licensed per CPU, and select the number of CPUs/cores correspondinglySlawek Guzek
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-035
Answers
-
There is no server sizing guidelines document for newer NAV versions as far as I know. The most 'recent' one published by Microsoft was for NAV 2013. You can try googling it and use recommendations described in there as a starting point.
Having said that - it is enough to have one nasty report run to blow up memory requirements for the NST server. The hardware is relatively cheap comparing to software licenses so rather than trying to find 'exact memory' buy as much as you can afford.
SQL sizing-wise the max memory is dictated either by the SQL Server version, or by projected sizes of all (active) databases hosted on that box size. SQL Server will not use more that necessary to keep in memory all the database hosted on it, so if you plan only one NAV database on the server, which will grow to, say 40+GB in a few years time, there is a very little sense buying more that 48 - 64 GB of RAM for such server
CPU wise it is a bit more complicated. Look what else will run run on your server, if you will have any other software on it licensed per CPU, and select the number of CPUs/cores correspondinglySlawek Guzek
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-035 -
Thanks Slawek good info , i have a SQL Db server with 24gb with 7 Database running at 80 to 85% at all times .. and an Application server with 32GB running from 89 to 95% utilization ... What would you recommend in terms of memory config for both systems .. CD0
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