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.
| Author |
Topic |
|
jhnegrao
Yak Posting Veteran
81 Posts |
 Posted - 2007-09-05 : 15:36:44
|
| Hello, All!Good Afternoon!I'm having a strange situation in my SQL SErver 2000 SP3a with 4 Processors, 4GB of RAM and high-end disk sub-system.I migrate a specific database from another instance with SQL SErver 2000 SP3a too to this new server with more hardware resource than another one.The application that access this DataBase stablish a connection with SQL SErver using TCP/IP, everything works fine. So, if I let the connection "sleeping", or better, if I let the connection idle for amount of time, I need to stablish the connection to ther SQL SErver again.I hadn't the same situation in the old instance as I having. I think that it's happening because the other instance was dedicated to this application and that new Instance don't.In this new Instance I have many other connections simultaneously, about 200 processes.Anybody knows what's going on? Are there any settings to change this time-out configuration just for a specific connections?ThanksBest Regards |
|
|
jhnegrao
Yak Posting Veteran
81 Posts |
Posted - 2007-09-05 : 15:45:18
|
| Just to complete the sintomns.To access the application, I need to logon in the application. This logon, stablish a connection to SQL SErver and enable the interface to work.When I let the connection idle for a little period of time (more or less - 5 minutes), I need to logon on the application again. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-05 : 21:56:28
|
| How does the app connect to sql server? Ole db or odbc or something else? What's sql edition? |
|
|
|
jhnegrao
Yak Posting Veteran
81 Posts |
Posted - 2007-09-06 : 08:18:02
|
| Hi, The application connect to SQL SErver using OLEDB configured inside the application. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
jhnegrao
Yak Posting Veteran
81 Posts |
Posted - 2007-09-06 : 11:59:48
|
| Hi, Madhivanan!Thanks a lot.That link was greatfull to me.I gonna check all of the itens related in the link and try to solve.ThanksJuliano |
|
|
|
|
|
|
|
|
Connection Time-out