SQL Server Performance Forum – Threads Archive

session timeout

Hi all,
Is it possible to set a session timeout on sql 2000 or 2005 ?
If so, where? TIA
acki

I don’t think there is anything sql server called session timeout but "query governor cost limit" Option is the one you are looking for…
Check BOL topic "query governor cost limit Option" MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

What session timeout you are referring?
As suggested you can set on the query governor cost limit option.
If you are using ASP.net application then thishttp://www.dbazine.com/sql/sql-articles/cook9 will help you.
Vyas’shttp://vyaskn.tripod.com/watch_your_timeouts.htm will help you too.
Now comes the question how long this value can exist? By default, in ASP.NET its 20 minutes.
As you all know, we can set the session timeout for an application in our web.config itself. But if you were thinking that 90 minutes is the maximum limit we can set for it, then you are wrong. The maximum limit for session timeout is 525,600 minutes — i.e., 365 days x 24 hours x 60 min. Yep you are right .. its valid for one year.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

]]>