Re: Connection to mssql server on windows slow

[Barry Books]

I had a similar problem with db2 on a mainframe. The firewall would end the
database connection after while and the data base driver would not know
that. I solved it by adding an is alive query to the database pool config

Re: Connection to mssql server on windows slow

[Rui Pacheco]

How is the load on each machine when that happens?

On 6/2/06, James Sherwood <[EMAIL PROTECTED]> wrote:


Hello,

For a few of our sites we use a MSSQL server 2000 database running on a
win2003 server and connect to it from our linux box.  Everything was fine
until a few days ago when we added a router/firewall to the win2003
server.

Now when we try to access those sites, sometimes they work great,
sometimes
the connection is VERY slow, so slow sometimes the page just wont come up
and hangs.

We use Tapestry with Torque.

Anyone have ANY ideas as to what it might be or how to debug it as we have
tried everything we can think of?

Thanks in advance,
James


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





--
Cumprimentos,
Rui Pacheco

Connection to mssql server on windows slow

[James Sherwood]

Hello,

For a few of our sites we use a MSSQL server 2000 database running on a 
win2003 server and connect to it from our linux box.  Everything was fine 
until a few days ago when we added a router/firewall to the win2003 server.


Now when we try to access those sites, sometimes they work great, sometimes 
the connection is VERY slow, so slow sometimes the page just wont come up 
and hangs.


We use Tapestry with Torque.

Anyone have ANY ideas as to what it might be or how to debug it as we have 
tried everything we can think of?


Thanks in advance,
James 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]