DPAS SCR: 01736

• SCR Number
  01736
• Title
  ASP.NET Session State
• DPAS Module
  PA
• Reporting Organization
  Leidos
• State
  Done
• History
  Submitted 11/24/2021
• Description

  Description:
  During periods of high usage, in production, the SQL server session state database provider experiences intermittent locking and latch contention, which reduces overall system performance, stability and responsiveness.
  

   

  Recommended:
  

  Update the following environments to use the ASP.NET Session State with SQL Server In-Memory OLTP Database Session Provider
  

   

  Mission Critical:
  

  With the additional users being added to support Air Force Maintenance, this change is required
  

   

  Benefits:
  Reduced locking and latch contention resulting in better performance, stability and responsiveness.
  

   

  Users:
  Yes. All users could see an improvements with this change.
  

   

  Completed -  Release 2021.4  - 10 December 2021