# NAvision performance has degraded terribly
**URL:** https://www.dynamicsuser.net/t/navision-performance-has-degraded-terribly/55196
**Category:** Technical Forum
**Created:** [October 3, 2014, 11:17am UTC](https://www.dynamicsuser.net/t/navision-performance-has-degraded-terribly/55196 "2014-10-03T11:17:49Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@jamesjay](https://www.dynamicsuser.net/u/jamesjay)
#### Post date: [October 3, 2014, 11:17am UTC](https://www.dynamicsuser.net/t/navision-performance-has-degraded-terribly/55196/1 "2014-10-03T11:17:49Z")
Good day all
First up our Environment is a SQL 2012 sp1 on a Server 2008 R2.
the navision servers and clients are on 2 virtual servers with server 2012 and an average of 15 - 20 users
spit between (nav001 and nav002) them hitting the same db .
our db is currently 56 GB and also has reporting services installed on it that run against the DB.
we do have some customization, but the users are complaining that the system is slow and that it has been slow for a while sometimes hanging.
---
### Author:  [@modric](https://www.dynamicsuser.net/u/modric)
#### Post date: [October 3, 2014, 6:43pm UTC](https://www.dynamicsuser.net/t/navision-performance-has-degraded-terribly/55196/2 "2014-10-03T18:43:51Z")
It’s difficult to give you a concrete advice, because many factors are involved. Not knowing details about your system - setup, SQL tweaking, workflow habits etc etc I can only advice to search forum, we have here great amount of threads about performance issues.
Hardware part looks OK, only ~20 users and (correctly !) done mods should not cause any problems either.
Was the system slow from the beginning or is it slowing down over time? Total hanging for a couple of minutes indicate DB locking problems, solution for such cases both by MSSQL tweaking and NAV setup changes can be found searching the forum…
---
### Author:  [@stryk](https://www.dynamicsuser.net/u/stryk)
#### Post date: [October 6, 2014, 7:50am UTC](https://www.dynamicsuser.net/t/navision-performance-has-degraded-terribly/55196/3 "2014-10-06T07:50:43Z")
Well, degraded Performance could have many reasons - thus there are plenty possible Solutions.
Without a detailed assessment it’s hard to tell what’s wrong; usually it’s a mix of bad configuration, expensive queries and blocks …
What NAV Version are you using?
---
### Author:  [@jamesjay](https://www.dynamicsuser.net/u/jamesjay)
#### Post date: [October 6, 2014, 9:00am UTC](https://www.dynamicsuser.net/t/navision-performance-has-degraded-terribly/55196/4 "2014-10-06T09:00:54Z")
Thanks for a reply, we are on 2013 R2
---
### Author:  [@stryk](https://www.dynamicsuser.net/u/stryk)
#### Post date: [October 12, 2014, 6:41pm UTC](https://www.dynamicsuser.net/t/navision-performance-has-degraded-terribly/55196/5 "2014-10-12T18:41:38Z")
OK, so there are plenty of Areas to investigate:
SQL Server sizing & configuration
NAV Service Tier sizing & configuration
Expensive Queries & Indexing
Blocks & Deadlock
Database Maintenance
Tools to investigate:
Windows Performance Monitor (Platforms)
SQL Profiler (Expensive Queries)
NAV Debugger SQL Trace (Expensive Queries)
NAV Application Profiler (Expensive Queries/Problematic Code)
This, this is just a general answer, but without an exact problem descriptions it’s hard to advise anything more specific …
---
### Author:  [@stryk](https://www.dynamicsuser.net/u/stryk)
#### Post date: [October 12, 2014, 6:43pm UTC](https://www.dynamicsuser.net/t/navision-performance-has-degraded-terribly/55196/6 "2014-10-12T18:43:12Z")
And maybe this could help, too:
[http://www.youtube.com/playlist?list=PLLKA5LIGcLFDgxxQu5ZlOC\_1eWHDLeB0R](http://www.youtube.com/playlist?list=PLLKA5LIGcLFDgxxQu5ZlOC_1eWHDLeB0R)
[http://www.youtube.com/playlist?list=PLLKA5LIGcLFC4Aqwnq8yNfs1rc96XwAiO](http://www.youtube.com/playlist?list=PLLKA5LIGcLFC4Aqwnq8yNfs1rc96XwAiO)
---
### Author:  [@anfinnur](https://www.dynamicsuser.net/u/anfinnur)
#### Post date: [October 14, 2014, 2:28pm UTC](https://www.dynamicsuser.net/t/navision-performance-has-degraded-terribly/55196/7 "2014-10-14T14:28:40Z")
It depends where NAV 2013r2 “is said” to be slow.
Examples:
One of our customers says that e.g. operation “calculation of interest” is much much faster than before (NAV 4 Native).
But to post a (=one) salesorder is “pain-in-the-arse-slow”.
When they tried batch-posting salesorders the said that posting 20 orders is as time-consuming as posting one single order.