SQLServer vs StateServer for ASP.NET Session State Performance
State Server is faster because it stores session data in an in-memory dictionary. SQL Server is slower because it’s stored in a database which persists data to disk. SQL server is also slower because everything is stored in one table which leads to contention as more and more clients access/update the session data. SQL server … Read more