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.
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…
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?
Thanks for a reply, we are on 2013 R2
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 …
And maybe this could help, too:
http://www.youtube.com/playlist?list=PLLKA5LIGcLFDgxxQu5ZlOC_1eWHDLeB0R
http://www.youtube.com/playlist?list=PLLKA5LIGcLFC4Aqwnq8yNfs1rc96XwAiO
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.