Kill session in NAV 2013

_mon_
_mon_ Member Posts: 42
edited 2014-04-17 in NAV Three Tier
In previous versiones (<NAV 2013) in file, database, information, sessions, current sessiones, you could kill sessions.
In NAV 2013, in sessions you can see the NAV sessions.
But, how can you kill any session in NAV 2013?

Answers

  • ara3n
    ara3n Member Posts: 9,258
    http://www.dynamicsblog.at/index.php/20 ... manageme-1
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • _mon_
    _mon_ Member Posts: 42
    Thank you!
    :D
  • ara3n
    ara3n Member Posts: 9,258
    You are welcome.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Rob_Hansen
    Rob_Hansen Member Posts: 296
    Is there no idle time tracking for sessions in NAV 2013?
    Rob Hansen
    http://www.epimatic.com
  • ara3n
    ara3n Member Posts: 9,258
    I didn't see anything in virtual tables. But there are two settings in Customsettings.config


    <!--
    Sets the number of months sessions older will be purged from teh session event table.
    -->
    <add key="SessionEventTableRetainPeriod" value="3" />
    <!--
    Sets the weekly frequency the session event table will be purged. The default value being Sunday 6:00.
    This means that an attempt will be made to purge all not active sessions between 6:00 and the 6:00 + SessionEventTablePurgeLookupPeriod.
    -->
    <add key="SessionEventTablePurgeFrequency" value="0 6:00" />
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Ravi_Thakkar
    Ravi_Thakkar Member Posts: 392
    Hello Everybody,

    How can we identify the session idle time for Navision 2013?

    Also, please suggest how to kill the idle session which is more idle than the user defined time?
    Ravi_Thakkar
    Ahmedabad, Gujarat, India
    E Mail : ravi.thakkar@hotmail.com
  • RachelSoon
    RachelSoon Member Posts: 202
    Dear All,
    Is there any particular reason that NAV2013 does not enable kill session at the first?

    base on the link given by ara3n, the code to add to NAV2013 to enable to kill session is straight forward.

    So, just wondering if there is any reasons that it's not enable. Could it be there is not indication of the idle time? or NAV2013 can handle by itself.

    Please advise.

    Thank you.

    regards,
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    NAV2013 uses connection pooling on SQL Server. From SQL's perspective you don't have a clue who is on what connection. This makes doing anything from SQL Servers perspective very difficult, if not impossible.
    Marije Brummel | Freelance Business Central Specialist
  • RachelSoon
    RachelSoon Member Posts: 202
    hi Mark,
    Thanks for the useful input.
  • MBrodie1979
    MBrodie1979 Member Posts: 21
    This is so AWESOME! =D>
  • spukur
    spukur Member Posts: 1
    Very useful!

    Thanks

Categories