unanswered tcp keepalive packets
I have a problem with tcp keep alive between a M$ SQL Server 2008 and a SUSE Linux Enterprise Server 11 SP1 and sql queries that take a longer time. With a standalone M$ SQL Server 2008 everything works fine. But with a clustered M$ SQL Server 2008 the network connection will be closed after 30s.
With a tcpdump i could see:
The linux server opens a database connection to the M$ SQL server and put the query. After 30s the SQL server sends a tcp keep alive package.
The package from the standalone M$ SQL server will be answered correct and the connection stays alive. The package from the clustered SQL server will not be answered by the linux server.
Kernel version of the SUSE Linux system: 18.104.22.168-0.3-default #1 SMP 2011-02-25 13:36:59 +0100 x86_64 x86_64 x86_64 GNU/Linux
I have attached a tcpdump with the working connection and a tcpdump with the dropped keepalive packets.
I'm deeply greatful, if somebody could help me.