session timeouts - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

session timeouts

Author

Topic

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-01-06 : 10:50:56

hello,
I have a colleague in the office who implemented a .net site without using cookies, but only session variables in the webconfig file, set as a default of 20minutes

Now the site is heavily hit from the same location being an educational portal and users are complaining of timeouts

Please advice, whats wrong here ?

Afrika

MichaelP
Jedi Yak

2489 Posts

Posted - 2006-01-06 : 10:59:29

A few questions:
1. What type of session is he using? InProc? SQL Server?

2. Users are complaining of timeouts. Are you sure they are session timeouts and not SQL timeouts?

Michael

<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-01-06 : 11:03:24

1. .net
2. session

afrika

jhermiz

3564 Posts

Posted - 2006-01-06 : 11:25:31

This is normal for session based sites, a couple of things to do, find out if the session information is stored at each page load event of each seperate page so that the info remains intact.

Otherwise there is not much you can do besides modifying the timeout which it looks like you have set to 20.

Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]

RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]

MichaelP
Jedi Yak

2489 Posts

Posted - 2006-01-06 : 12:09:06

There are different kinds of .net Session. Look at the sessionState node in the Web.config. It can be Off, InProc, StateServer, or SQLServer.

Are the users complaining about EARLY timeouts, or just the timeouts after 20 minutes? You could change the timeout in the web.config and that might help things out a bit.

Michael

<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources