Options

NAV 2013 PERFOMANCE TOOL

karuchuakaruchua Member Posts: 151
edited 2014-05-23 in NAV Three Tier
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?

Comments

  • Options
    bbrownbbrown Member Posts: 3,268
    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.
    There are no bugs - only undocumented features.
  • Options
    kinekine Member Posts: 12,562
    And I started to use PAL tool to create report about the different aspects of the whole system.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    jreynoldsjreynolds Member Posts: 175
    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.
Sign In or Register to comment.