On my current project, I’m building an (ASP.NET MVC) web application. The plan is to deploy it to a web farm, so we had to replace the default in memory session state provider with a persistent one.
We did our own performance tests comparing multiple possible solutions(SQL Session State, Redis, AppFabric Caching, …). The clear winner for us was Redis.
On SlideShare I found the following presentation confirming our own conclusions: