NAV 2015 TRACKING SESSIONS, USERS ACTIVITY, CHANGE LOG


NAV 2015 TRACKING SESSIONS, USERS ACTIVITY, CHANGE LOG

A simple post about NAV 2015 Tracking Technology, based on MSDN NAV Online Help.

 1) TRACKING SESSIONS

NAV 2015 Active Sessions Table

“Active Session”  Table

Specifies sessions that are currently active and are connected to a Microsoft Dynamics NAV Server instance. An active session can be in use or idle.

This table can contain sessions that are not active, before those are removed from the table. For example, if a Microsoft Dynamics NAV Server instance stops responding, then the table can contain sessions that are not active. When the Microsoft Dynamics NAV Server instance restarts, it deletes from the table the sessions that are not active. If the Microsoft Dynamics NAV Server instance never restarts, then other the Microsoft Dynamics NAV Server instances delete the sessions that are not active.”

https://msdn.microsoft.com/en-us/library/hh895997(v=nav.80).aspx

Field Location
Session ID Field, Active Session Table Using Microsoft Dynamics NAV
Database Name Field, Active Session Table Using Microsoft Dynamics NAV
Login Datetime Field, Active Session Table Using Microsoft Dynamics NAV
User ID Field, Active Session Table Using Microsoft Dynamics NAV
User SID Field, Active Session Table Using Microsoft Dynamics NAV
Server Computer Name Field, Active Session Table Using Microsoft Dynamics NAV
Client Computer Name Field, Active Session Table Using Microsoft Dynamics NAV
Client Type Field, Active Session Table Using Microsoft Dynamics NAV
Server Instance Name Field, Active Session Table Using Microsoft Dynamics NAV
Server Instance ID Field, Active Session Table Using Microsoft Dynamics NAV

 “Active Sessions List” Page > based on “Session” Table

Client Type

> Windows Client, Web Client, Tablet  Client, Web Services (& Odata Access), Background Services (NAV Server Service or NAS Service)

 NAv 1

2) TRACKING USERS ACTIVITY & CHANGE LOG

Standard NAV By Design functionalities

Actually NAV has 2 separate tables to track user activities  (only NAV activities handled by NAV Server)

>  User Time Registers Table > login\logout with user activities timing

“Specifies how much time an individual user works on the accounts.

The User Time Register table is useful for accounting firms that want to register the amount of time spent working on each company. You may also want to see who has worked on the companies in which period.

To use the User Time Register table, two conditions must be fulfilled: the user must be set up with a personal User ID in the security system and there must be a check mark in the Register Time field.

The program registers time in whole minutes, rounding up or down.”

https://msdn.microsoft.com/en-us/library/hh169225(v=nav.80).aspx

NAV 2

User Time Registers Table Detail

Field Location
User ID Field, User Time Register Table General Ledger
Minutes Field, User Time Register Table General Ledger
Date Field, User Time Register Table General Ledger

>  Change Log Table > data modifications (insert, delete, modify, previous record before modify)

By Default these tables are not configured & tracking isn’t active, user can activate these functions On-Demand

“The change log in Microsoft Dynamics NAV logs changes that are made to data in the tables that you track. In the change log, entries are chronologically ordered and show changes that are made to the fields on the specified tables.

The change log collects all changes that are made to the table.”

https://msdn.microsoft.com/en-us/library/hh167300(v=nav.80).aspx

nav 3

Field Location
Primary Key Field, Change Log Setup Table General Ledger
Change Log Activated Field, Change Log Setup Table General Ledger
Annunci

8 commenti

  1. […] Rispondi Hi Guys, another post of “ALL About” Series, in this case, some people have asked me about NAV configuration and how to configure NAV Server for better performance (Boosting NAV..);  also in Microsoft Forum there are several posts about this topic, i searched and collected a variety of useful information for a correct NAV Server configuration. Documents and Posts “Great White Paper” about typical questions around the number of users or tenants, hardware requirements, scaling, and upgrading -> “…How to have a great configuration and “How-to Boost NAV”!! “This white paper provides detailed insight into the concepts and principles that support performance testing in Microsoft Dynamics NAV”. By outlining some sample goals from the start, it explains how you can use load testing to optimize your application and hardware to meet the customer and user requirements – addressing typical questions around the number of users or tenants, hardware requirements, scaling, and upgrading” Microsoft Dynamics NAV Performance Testing – White Paper http://www.archerpoint.com/sites/default/files/docs/ms-dynamics-nav-peformance-testing-wp.pdf Below some useful information about NAV Server Configuration. NAV Server Configuration Best Practices (from Whitepaper) 1) Number of Microsoft Dynamics NAV Service Tiers When a client connects to Microsoft Dynamics NAV Server, the load balancer will select a server and keep the connection open throughout the lifetime of the client. This means that setting up more servers behind a load balancer will increase the capacity of the cluster of Microsoft Dynamics NAV Service tiers. 2) Server Memory Each Microsoft Dynamics NAV Service tier needs 500Mb of memory to run. On top of that, the Microsoft Dynamics NAV Service tier needs memory for each active session, even if they are idle. The more pages the user have opened, the more memory gets allocated, but a good starting point for doing sizing calculations is around 10Mb per active session. Idle sessions are not terminated if they are running the Windows client. Server CPU (cores and speed) Faster CPU will get things done faster, and more cores can run more things in parallel. Idle sessions on the Microsoft Dynamics NAV Service tier don’t use any CPU power, except for generic housekeeping, which shouldn’t be counted. 3) Server CPU (cores and speed) Faster CPU will get things done faster, and more cores can run more things in parallel. Idle sessions on the Microsoft Dynamics NAV Service tier don’t use any CPU power, except for generic housekeeping, which shouldn’t be counted. Active sessions will use CPU power depending on what they do, but it is hard to generalize how much. For example, CPU power is used whenever the user is performing a task that requires the Microsoft Dynamics NAV Service tier to run some business logic or perform some UI logic or setup server pages. If the Microsoft Dynamics NAV Service tier does a lot of IO (SQL calls or client callbacks), then the CPU will be waiting for response and thus be loaded less. 4) Data Cache Size This is a Microsoft Dynamics NAV Server setting, which located in CustomSettings.config file. Sets the data cache size. This is an abstract value with contextual meaning on the type of the item being cached. <add key=”DataCacheSize” value=”9″ /> The number you specify in DataCacheSize setting determines how much memory is used for caching data. The actual amount of memory (in MB) allocated is 2n, where n is the value of the DataCacheSize setting: Value Memor y 9 (default) 512Mb 10 1Gb 11 2Gb 12 4Gb 13 8Gb 14 16Gb 15 32Gb … When running a single tenant system the default value of 9 is probably good. When running a multi-tenant system, the data cache is shared between all tenants. Set to 0 to disable cache. 5) Metadata Provider Cache Size This is a Microsoft Dynamics NAV Server setting, which located in CustomSettings.config file. Sets the Metadata Provider cache size (in number in objects cached). Set to 0 to disable cache. <add key=”MetadataProviderCacheSize” value=”150″ /> You can monitor the number of objects in the metadata cache by monitoring the following performance counter on the Microsoft Dynamics NAV Service tier. There is really NO REASON not to set this to a high value (like 10000) if you are not pressed on memory on the Microsoft Dynamics NAV Server. 6) Max Concurrent Calls This is a Microsoft Dynamics NAV Server setting, which is located in CustomSettings.config file. Maximum number of concurrent client calls that can be active on the Microsoft Dynamics NAV Server. To disable this setting set the value to “MaxValue”. <add key=”MaxConcurrentCalls” value=”40″ /> The number specified here determines how many concurrent calls the Service Tier is able to handle. The more cores in your server, the higher this value can be. GitHub organization for performance testing Microsoft Dynamics NAV GitHub You will find a couple of projects on GitHub, which contains some sample code on how to do performance tests. The GitHub organization is used to store the sample repositories and is available here: https://github.com/NAVPERF Others nice links Optimizing SQL Server Performance with Microsoft Dynamics NAV https://msdn.microsoft.com/en-us/dynamics-nav/optimizing-sql-server-performance-with-microsoft-dynamics-nav Blog about Performance https://navperformance.wordpress.com/ Performance Tuning Microsoft Dynamics NAV 2009 RTC and NAV 2013 http://www.archerpoint.com/blog/Posts/performance-tuning-microsoft-dynamics-nav-2009-and-nav-2013 Videos How Do I: Run NAV Performance Tests Using Visual Studio in Microsoft Dynamics NAV https://www.youtube.com/watch?v=IG-y8DsXqaQ Some my old posts here: Monitoring Microsoft Dynamics NAV 2015 Server Using “Performance Counters” https://robertostefanettinavblog.wordpress.com/2015/07/06/monitoring-microsoft-dynamics-nav-2015-server-using-performance-counters/ NAV 2015 TRACKING SESSIONS, USERS ACTIVITY, CHANGE LOG https://robertostefanettinavblog.wordpress.com/2015/06/09/nav-2015-tracking-sessions-users-activity-&#8230; […]

    Mi piace

I commenti sono chiusi.