Problem with MSDE 2000 5 minute keepalive over ISDN

Posted by mcrick on Server Fault See other posts from Server Fault or by mcrick
Published on 2010-05-06T14:30:36Z Indexed on 2010/05/06 14:38 UTC
Read the original article Hit count: 447

We have a SQL Server transactionally pushing replicate data to an MSDE 2000 SP3a subscriber over ISDN. Prior to a recent upgrade to bring us to the MSDE 2000 level we pushed to MSDE 1.

We are finding that there is now a 5 minute keepalive being instigated from MSDE 2000 which we cannot account for. Further, we can find no way to either disable it or lengthen the keepalive interval. Not surprisingly, we are finding a marked increase in ISDN line costs due to these previously non-existent keepalive packets!

Please note that we are assuming that it is an MSDE 2000 server issue, but it could equally be some behaviour related to the way that replication is operating on MSDE 2000. Unfortunately, as yet, we have not identified a replication configuration parameter that affects the keepalive in any way.

Can anyone advise how we might indentify a root cause for this problem (and ideally a fix)?

© Server Fault or respective owner

Problem with MSDE 2000 5 minute keepalive over ISDN

Posted by mcrick on Server Fault See other posts from Server Fault or by mcrick
Published on 2010-05-06T13:44:31Z Indexed on 2010/05/06 15:48 UTC
Read the original article Hit count: 447

We have a SQL Server transactionally pushing replicate data to an MSDE 2000 SP3a subscriber over ISDN. Prior to a recent upgrade to bring us to the MSDE 2000 level we pushed to MSDE 1.

We are finding that there is now a 5 minute keepalive being instigated from MSDE 2000 which we cannot account for. Further, we can find no way to either disable it or lengthen the keepalive interval. Not surprisingly, we are finding a marked increase in ISDN line costs due to these previously non-existent keepalive packets!

Please note that we are assuming that it is an MSDE 2000 server issue, but it could equally be some behaviour related to the way that replication is operating on MSDE 2000. Unfortunately, as yet, we have not identified a replication configuration parameter that affects the keepalive in any way.

Can anyone advise how we might indentify a root cause for this problem (and ideally a fix)?

© Server Fault or respective owner

Related posts about sql-server

Related posts about msde