NAV 2013 PERFOMANCE TOOL

karuchua

All,


what's the best tool for measuring NAV 2013 R2 performance and checking what's hogging the system when some times there are locking issues and cant identify where its coming from?

bbrown

I think "best tool" is somewhat a matter of personal opinion and what you are use to working with. I tend to lean toward SQL Profiler as the starting point. I will collect several hours of data for analysis. I look for things like high I/O, long running queries, blocking (especially lock timeouts), or deadlocks. Then I will work from there.

There is also the "tool" of talking to the users. Often you can learn much by what they tell you.

I also tend to run Windows Performance Monitor to check on any hardware related issues. An often overlooked area.

kine

And I started to use PAL tool to create report about the different aspects of the whole system.

jreynolds

NAV 2013 R2 uses Event Tracing for Windows (ETW) to record what's happening on the NAV Server (http://msdn.microsoft.com/en-us/library/dn271688(v=nav.71).aspx. Check out this site https://navappprofiler.codeplex.com/, for a way to access this data.