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