Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Lost ADS connections when MS-SQL is busy

3 posts in Networking Last posting was on 2009-08-04 15:01:06.0Z
Phil Turner Posted on 2009-07-30 10:43:11.0Z
From: "Phil Turner" <phil@jotika.co.uk>
Newsgroups: advantage.networking
Subject: Lost ADS connections when MS-SQL is busy
Date: Thu, 30 Jul 2009 11:43:11 +0100
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 82.37.220.37
Message-ID: <4a7178fc@solutions.advantagedatabase.com>
X-Trace: 30 Jul 2009 04:42:04 -0700, 82.37.220.37
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.37.220.37
Xref: solutions.advantagedatabase.com Advantage.Networking:883
Article PK: 1132296

We have a couple of sites that run MS SQL server on the same hardware as
ADS. On occasions, the SQL server gets very busy to the point where our
clients disconnect from ADS. This can last a couple of hours.

We do not manage these servers so have no control over the MS SQL
configuration. No other applications on the server or clients suffers during
these busy periods.

Does anyone know if we can check any of the SQL setup for memory/performance
parameters and how we can reduce it's impact on ADS?
Are there any settings for ADS that would make it more robust in this setup?

Thanks for any advice on this.


Lance Schmidt Posted on 2009-07-30 15:12:57.0Z
From: "Lance Schmidt" <LanceSc@ExtendSys.com>
Newsgroups: advantage.networking
References: <4a7178fc@solutions.advantagedatabase.com>
Subject: Re: Lost ADS connections when MS-SQL is busy
Date: Thu, 30 Jul 2009 09:12:57 -0600
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 10.24.38.117
Message-ID: <4a71b865@solutions.advantagedatabase.com>
X-Trace: 30 Jul 2009 09:12:37 -0700, 10.24.38.117
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.117
Xref: solutions.advantagedatabase.com Advantage.Networking:884
Article PK: 1132295

Hi Phil,

It sounds like MS SQL server could be starving the Advantage Database Server
of resources. When this happens the clients are timing out because the
server is not responding to there keep alive packets. In this situation I
would suggest switching to TCP/IP. Because TCP/IP is a connected protocol
the Advantage Database Server does not need to respond to keep alive
packets. Your clients won't be disconnected; however, your perfomance will
be limited by the amount of resources MS SQL Server leaves us.

Best Regards,

Lance Schmidt
Advantage R&D

"Phil Turner" <phil@jotika.co.uk> wrote in message
news:4a7178fc@solutions.advantagedatabase.com...
> We have a couple of sites that run MS SQL server on the same hardware as
> ADS. On occasions, the SQL server gets very busy to the point where our
> clients disconnect from ADS. This can last a couple of hours.
>
> We do not manage these servers so have no control over the MS SQL
> configuration. No other applications on the server or clients suffers
> during these busy periods.
>
> Does anyone know if we can check any of the SQL setup for
> memory/performance parameters and how we can reduce it's impact on ADS?
> Are there any settings for ADS that would make it more robust in this
> setup?
>
> Thanks for any advice on this.
>
>


Phil Turner Posted on 2009-08-04 15:01:06.0Z
From: "Phil Turner" <phil@jotika.co.uk>
Newsgroups: advantage.networking
References: <4a7178fc@solutions.advantagedatabase.com> <4a71b865@solutions.advantagedatabase.com>
Subject: Re: Lost ADS connections when MS-SQL is busy
Date: Tue, 4 Aug 2009 16:01:06 +0100
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 82.37.220.37
Message-ID: <4a784cf3@solutions.advantagedatabase.com>
X-Trace: 4 Aug 2009 09:00:03 -0700, 82.37.220.37
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.37.220.37
Xref: solutions.advantagedatabase.com Advantage.Networking:886
Article PK: 1132298

Thanks Lance.

I have just checked with the customer and they are already setup to use TCP
and not UDP. I am not sure now if we actually do get disconnected - Our
application exits immediately.
I log entries in the windows event log during the exit code of our EXE and
DLL's - these do not appear which suggests that our app is getting
terminated very quickly.

Their IT support are planning to move the MS SQL components over to a spare
workstation in the next week or so. Hopefully this will prove that it is MS
SQL causing the problems and not our software+ADS.
Following that they will install a new dedicated server for MS SQL.

Phil