SessionState & ASP.NET

[Komil13]

Hi Guys,

I have a website that is using Session State to store all the session info. Our default.aspx page (homepage) does not have any code that hits the database. However, we discovered that when the SQL Server is not accessable, the site doesn't even come up. We traced it to the web.config file.

Does the <sessionState> tag in the web.config cause a database hit. If so, is there a way to stop that?

Thanks for your help.

KP

 

[cappmgr]

What is the mode in your sessionState section of your web.config?
Marty

 

[Komil13]

mode is set to SQLServer

KP

 

[dace]

That would be why- it's storing your session states in the database. You can change this to InProc to store it in memory on the webserver instead - this should fix the problem, but be careful of other factors - this will greatly increase the amount of web-server resources consumed, for example.