Recently faced a problem of table locking which goes in not responding stage and finally user close the tab ,but when user opens the session again it actually messed up the critical data (It seems unimaginable force was roaming that time when this happens). Eventually after trying couple of days for data correction I need to contact Microsoft to restore the database.
Tag Archives: Kill
NAV Services and Sessions: Counting, Killing, Timeout
Understanding and Configuring Session Timeout
When you start the Microsoft Dynamics NAV Windows client or the Microsoft Dynamics NAV Web client, a connection is established with the Microsoft Dynamics NAV Server instance, and a corresponding session is added on Microsoft Dynamics NAV Server.
Kill Sessions in Dynamics NAV
In the older versions of Microsoft Dynamics NAV where the classic client was available you could go to the sessions table and just delete a session to kill it. This was very useful for a number of reasons but it does not work like that anymore in the windows client of version 2013 and 2015.
SQL kill inactive NAV sessions
// KILL SQL INACTIVE SESSIONS FOR NAV APPLICATIONS
// ONLY FOR SLEEPING SESSIONS
a very Simple SQL Stored Procedure to ‘kill’ sql inactive sessions
idle (sleeping) for 10 minutes related to “Nav Client” applications
NAV Three Tier – Auto Kill Idle Session
This question was asked by one of my Friend, and i thought i will share will all.
Normally we have some code written till NAV 2009 or in SQL to kill an Idle Navision Session.
Kill Idle Connections
To save concurrent uses in NAV it might be a good idea to kill idle connections automatically.