I'm running web application in load balanced environment. I'm storing session state in the database (ASP.NET 2.0 and SQL Server 2005).
My question is how often database will be hit to retrieve session state data. What I'm wondering really is whether in this scenario it's better to store a few variables in database or in session state (which is in db anyway)?
I would expect that session state will be cached somehow and therefore database will be hit less times if variables will be stored in session state compared to storing them in the database.