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.

Dual Core Processing

2 posts in Networking Last posting was on 2005-12-29 09:17:54.0Z
Mark St Laurent Posted on 2005-12-27 22:30:18.0Z
From: "Mark St Laurent" <stormrunner'_removethis'@comcast.net>
Newsgroups: advantage.networking
Subject: Dual Core Processing
Date: Tue, 27 Dec 2005 14:30:18 -0800
Lines: 8
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 68.125.154.177
Message-ID: <43b1bfc5@solutions.advantagedatabase.com>
X-Trace: 27 Dec 2005 15:27:17 -0700, 68.125.154.177
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!68.125.154.177
Xref: solutions.advantagedatabase.com Advantage.Networking:573
Article PK: 1131996

Does Advantage 7.1 make use of the dual core processing. Our current box
often pegs processor with times, System Idle =1060:00:00 ads.exe = 75:00:00.
When ads active often tops 90% for 60 - 90 secs. This is probably normal but
when it occurs remote connections to the machine stall. I'm wondering if in
a dual core or dual processor situation if ads might only monopolize one
core or cpu leaving the other available for background services etc.


Joachim Duerr (ADS Support) Posted on 2005-12-29 09:17:54.0Z
From: "Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de>
Subject: Re: Dual Core Processing
Newsgroups: Advantage.Networking
References: <43b1bfc5@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.17.6.5
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 195.2.185.25
Message-ID: <43b3a9c2@solutions.advantagedatabase.com>
Date: 29 Dec 2005 02:17:54 -0700
X-Trace: 29 Dec 2005 02:17:54 -0700, 195.2.185.25
Lines: 29
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.2.185.25
Xref: solutions.advantagedatabase.com Advantage.Networking:574
Article PK: 1131997


Mark St Laurent wrote in <43b1bfc5@solutions.advantagedatabase.com>:

> Does Advantage 7.1 make use of the dual core processing. Our current
> box often pegs processor with times, System Idle =1060:00:00 ads.exe
> = 75:00:00. When ads active often tops 90% for 60 - 90 secs. This is
> probably normal but when it occurs remote connections to the machine
> stall. I'm wondering if in a dual core or dual processor situation if
> ads might only monopolize one core or cpu leaving the other available
> for background services etc.

ADS is multi threaded and uses all available processors.
How much each processor is used depends on many things:
1) Operating system
Netware has a different threading model and a thread must be send to a
specific processor, Windows does all the threading on OS level and the
application has no influense on which processore which thread runs
2) application
if ADS just uses one worker thread, it will run on one processor and
not populate the others. There are some cases which prevent ADS from
working multi threaded and the operations have to be serialized (IIRC
usage of NTX indexes is one of the rare cases). Or if the application
just reads some records and leaves the database server idle for a long
time,...

--
Joachim Duerr
Senior Product Support Analyst (Advantage Database Server)
iAnywhere Solutions / Extended Systems
advantage[AT]extendsys.de