Connection to mssql server on windows slow

[James Sherwood <js...@rgisolutions.com>]

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: users-unsubscribe@tapestry.apache.org
For additional commands, e-mail: users-help@tapestry.apache.org

Re: Connection to mssql server on windows slow

[Barry Books <tr...@gmail.com>]

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 <ru...@gmail.com>]

How is the load on each machine when that happens?

On 6/2/06, James Sherwood <js...@rgisolutions.com> 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: users-unsubscribe@tapestry.apache.org
> For additional commands, e-mail: users-help@tapestry.apache.org
>
>


-- 
Cumprimentos,
Rui Pacheco