Problem

How to read the captured NAV Server log from performance monitor 

Solution

  1. Download PerfView from Official Microsoft Download Center or other safety place
  2. Extract the ZIP file and open PerfView.exe
  3. Find out the .etl file that captured by "Performance Monitor" tools, you can locate it in Data Collection Sets View in that tools


  4. After open the .etl file by double click, double click "Events" to check which NAV Executing event logs
  5. Some event maybe more interesting, for example "ExecuteALFunction" record which functions/object has been executed during that period
    There will be Object ID, Object Type, Function Name, Execution User etc.
    As a result, some heavy execution resources and locate which user can ask for their specific workflow.

    There also some logs related to database operation, which also able to read the SQL being execute for read/write.