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
- 264 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
NAV 2013 R2 slow performance client
StefanPit
Member Posts: 12
Hi all,
At our company we have a seperate NAV 2013 R2 app and DB server (clustered). We just had the NAV 2013 app server and DB server installed but I came to notice that the performance of the NAV 2013 R2 client (on a destop computer) is rather poor. Even when I install the client on the server the performance is rather bad. The client just does not respond as quick as I think it should. With the hardware we have the performance should be pretty good but something is holding is back and I don't know what. I'm aware that my story is rather foggy and maybe not detailed enough but if you guys need any more details please ask.
Specs:
NAV 2013 R2 app server:
Operating System: Microsoft Windows Server 2012 R2 Standard (x64) Build 9600
Computer Brand Name: HP ProLiant DL380p Gen8
CPU Brand Name: 2x Intel(R) Xeon(R) CPU E5-2650 0 @ 2.00GHz
Total Memory Size: 128 GBytes
MS SQL server:
Operating System: Microsoft Windows Server 2012 R2 Standard (x64) Build 9600
MS SQL server: Microsoft SQL Server 2012 Standard (64-bit)
Computer Brand Name: HP ProLiant DL380p Gen8
CPU Brand Name: 2x Intel(R) Xeon(R) CPU E5-2650 0 @ 2.00GHz
Total Memory Size: 128 GBytes
Stefan
At our company we have a seperate NAV 2013 R2 app and DB server (clustered). We just had the NAV 2013 app server and DB server installed but I came to notice that the performance of the NAV 2013 R2 client (on a destop computer) is rather poor. Even when I install the client on the server the performance is rather bad. The client just does not respond as quick as I think it should. With the hardware we have the performance should be pretty good but something is holding is back and I don't know what. I'm aware that my story is rather foggy and maybe not detailed enough but if you guys need any more details please ask.
Specs:
NAV 2013 R2 app server:
Operating System: Microsoft Windows Server 2012 R2 Standard (x64) Build 9600
Computer Brand Name: HP ProLiant DL380p Gen8
CPU Brand Name: 2x Intel(R) Xeon(R) CPU E5-2650 0 @ 2.00GHz
Total Memory Size: 128 GBytes
MS SQL server:
Operating System: Microsoft Windows Server 2012 R2 Standard (x64) Build 9600
MS SQL server: Microsoft SQL Server 2012 Standard (64-bit)
Computer Brand Name: HP ProLiant DL380p Gen8
CPU Brand Name: 2x Intel(R) Xeon(R) CPU E5-2650 0 @ 2.00GHz
Total Memory Size: 128 GBytes
Stefan
0
Comments
-Check if you have some network problem
-If they are virtualized, check on the host if they have enough resources.
-use TCP/IP but not Named Pipes for communication between NAV server and SQL server (disable Named Pipes in SQL server and use Sockets and not default as Nettype in NAV server.
-If you have an antivirus, don't let it check the SQL files (.MDF,.NDF,.LDF,.LOG,.TRN,.BAK)
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Thank you very much for your reply and I will check upon it today.
Stefan
Tommy
I've checked all the things that was posted but I don't see any approvements.
-Check if the servers are in high-performance mode. Need to check that in both Windows and BIOS of the servers.
Servers were allready in HP mode.
-Check if you have some network problem
No network problem found.
-If they are virtualized, check on the host if they have enough resources.
Servers are not virtualized.
-use TCP/IP but not Named Pipes for communication between NAV server and SQL server (disable Named Pipes in SQL server and use Sockets and not default as Nettype in NAV server.
I've changed named pipes into TCP/IP and changed the Nettype in the NST.
-If you have an antivirus, don't let it check the SQL files (.MDF,.NDF,.LDF,.LOG,.TRN,.BAK)
Currently no antivirus is installed yet. The server are still in a test phase.
-"Metadata Provider Cache Size"
I've changed the cache size to 1000 and restarted the NST but with no significant performance improvement.
While working with the NAV 2013 client I see a slight performance improvement (due to caching I think) but when I open a salesorder I see that the client need about 2/3 seconds to show the saleslines. When the system is idle for a while and you decide to work on it again then the performance is worse again.
IT can be an dns-problem
Turn off firewalls on sql and nav-servers.
Christer in Stockholm, Sweden
TrendMicro in the case.
Try uninstalling it on all servers.
It concerns a database that's modified by our ERP partner. Perhaps I should create a Cronus test DB and test the performance again?
Stefan
My answer about the BIOS HP settings was a bit premature :oops: . I assumed that our hardware supplier had set the BIOS HP setting to the maximum but they did not. I have done this myself and I see a increase of perfomance.
Stefan