C# MSSQL connection idle timeout.

BrokenArrows · 13-02-2013 2:49pm #1

Im connecting to an MSSQL 2005 and 2008 server in my C# project and getting some information.

Im leaving the connection open until the user closes the program and at that point i close the connection to the database.

What im trying to find out is if there is a Idle timeout on the server side in MSSQL.

If the user leaves the program open for a period of time will the server kill the connection? I cant seem to find a definitave answer with google.

Earthhorse · 14-02-2013 9:14pm

I hate to answer a question with a question but is there a reason you need to persist the connection in this manner?

BrokenArrows · 14-02-2013 9:29pm

Earthhorse wrote: »

I hate to answer a question with a question but is there a reason you need to persist the connection in this manner?

Not really no.

Ive actually changed it since asking this question to connect/disconnect after every query because i couldnt find a definate answer to the question.

Giblet · 15-02-2013 12:23am

You're doing it right now.

BrokenArrows · 15-02-2013 10:03am

Whats wrong with persisting a connection anyway?

srsly78 · 15-02-2013 10:14am

It hogs resources. What would happen if you had hundreds of clients that all kept their connections open?

BrokenArrows · 15-02-2013 10:56am

srsly78 wrote: »

It hogs resources. What would happen if you had hundreds of clients that all kept their connections open?

Ok fair enough.

Hadnt really considered that because its not going to happen in my scenario but its probably good practice to close stuff when im done.

C# MSSQL connection idle timeout.

Comments