Session Event Table

TechcronusTechcronus Member Posts: 4
edited 2015-05-06 in NAV Three Tier
Hi All,

We have a customer using Dynamics NAV 2013 R2 which is integrated with their custom made e-Commerce website. Their website is getting almost 4-5 million users per day. As a result we are getting more then 10 million records in the "Session Event" table per day.

We are truncating this table daily, but still tons of I/O requests are there for this table and hence getting locking issues.

Is there any possible way we can stop entering data in the "Session Event" table? Or filter out all instertion from the webusers?



  • Options
    lakshanvindanalakshanvindana Member Posts: 79
    find any other solution?
    Lakshan Kulawansa
    ERP Consultant - MS Dynamics NAV
  • Options
    bbrownbbrown Member Posts: 3,268
    What is the "Client Type" of these sessions?
    There are no bugs - only undocumented features.
  • Options
    TechcronusTechcronus Member Posts: 4
    It can be any. RTC, Web client, tablate client and the web users of the retail e-commerce site.

    Whenever any user login/logout, it creates one entry in the "Session Event" table. I want to stop this insertion.
  • Options
    Tarek_DemiatiTarek_Demiati Member Posts: 112
    With such high traffic I don't think I would let e-commerce users generate live connections directly to the ERP...
Sign In or Register to comment.