Improving ASP.NET Session State database performance by reducing block

home
asp.net
view story

1 Kicks

Improving ASP.NET Session State database performance by reducing block(sanjevsharma.blogspot.com)

submitted by sanjev.sharma(579) 4 years, 2 months ago

On a recent project, we encountered significant performance issues with their ASP.NET session state database. We had a combination of both large session state and a large number of concurrent sessions. They were regularly experiencing command timeouts on that database. In my investigation, curiously I found that a DELETE statement was the culprit. I tracked it to the DeleteExpiredSessions stored procedure. Looking at it, it seems tame enough:

add a comment |category: ASP.NET |Views: 14
Tweet