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.

ASE 15.7 advantages with Hyperthreading cores

4 posts in General Discussion Last posting was on 2012-02-21 19:29:57.0Z
rjlpedrosa Posted on 2012-02-20 14:25:33.0Z
Sender: 587d.4f42336a.1804289383@sybase.com
From: rjlpedrosa
Newsgroups: sybase.public.ase.general
Subject: ASE 15.7 advantages with Hyperthreading cores
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f4257dd.5fe3.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 20 Feb 2012 06:25:33 -0800
X-Trace: forums-1-dub 1329747933 172.20.134.41 (20 Feb 2012 06:25:33 -0800)
X-Original-Trace: 20 Feb 2012 06:25:33 -0800, 172.20.134.41
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30929
Article PK: 73819

Dear all,

I'm installing ASE 15.7 and I've a question about
Hyperthreading.
I'm using Intel(R) Xeon(R) CPU X5570 @ 2.93GHz with a total
of 8 cores.
However because hyperthreading is activated, linux (RedHat
5) recognizes 16 logical processes.

My question is, using ASE 15.7 with a threaded kernel, will
I have advantages on using hyperthreading?
For the number of engines should I use the number of logic
processes (for example 14 and leave 1 core for the OS) or
should I base it on the number of cores (for example 7)?

Thanks


Rob V Posted on 2012-02-21 19:29:57.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ASE 15.7 advantages with Hyperthreading cores
References: <4f4257dd.5fe3.1681692777@sybase.com>
In-Reply-To: <4f4257dd.5fe3.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f43f0b5$1@forums-1-dub>
Date: 21 Feb 2012 11:29:57 -0800
X-Trace: forums-1-dub 1329852597 10.22.241.152 (21 Feb 2012 11:29:57 -0800)
X-Original-Trace: 21 Feb 2012 11:29:57 -0800, vip152.sybase.com
Lines: 50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30934
Article PK: 73821


On 20-Feb-2012 15:25, rjlpedrosa wrote:
> Dear all,
>
> I'm installing ASE 15.7 and I've a question about
> Hyperthreading.
> I'm using Intel(R) Xeon(R) CPU X5570 @ 2.93GHz with a total
> of 8 cores.
> However because hyperthreading is activated, linux (RedHat
> 5) recognizes 16 logical processes.
>
> My question is, using ASE 15.7 with a threaded kernel, will
> I have advantages on using hyperthreading?
> For the number of engines should I use the number of logic
> processes (for example 14 and leave 1 core for the OS) or
> should I base it on the number of cores (for example 7)?
>
> Thanks

The 15.7 threaded kernel is more aiming to take advantage of the
threaded CPU architectures, for exmaple by getting benefits because
context switching can be reduced to threads instead of entire O/S processes.
Hyperthreading kicks in on a different level, and tries to make more
fully use of a core by allow multiple processes to use a single core by
exposing the core as multiple virtual cores. Whether that gives benefits
for database workload highly depends on your actual hardware and
workload etc. The T-series Sun SPARC CPUs for example did not do well at
all for database workload, though other brands of CPUs did better.
It could well be that enabling hyperthreading actually makes overall
performance worse , or has the effect of making the response time for
some (not all) queries. Or it can give an overall improvement. You'll
have to try and see.

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide" (new!)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


Cory Sane [TeamSybase] Posted on 2012-02-21 11:15:53.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <4f4257dd.5fe3.1681692777@sybase.com>
In-Reply-To: <4f4257dd.5fe3.1681692777@sybase.com>
Subject: Re: ASE 15.7 advantages with Hyperthreading cores
Lines: 27
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18463
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f437ce9$1@forums-1-dub>
Date: 21 Feb 2012 03:15:53 -0800
X-Trace: forums-1-dub 1329822953 10.22.241.152 (21 Feb 2012 03:15:53 -0800)
X-Original-Trace: 21 Feb 2012 03:15:53 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30931
Article PK: 73825

The best answer is:
"It Depends on your test results!!!"
How many concurrent CPUs does the dataserver program keep using?
If you only keep 6-7 engines active, then stay with the low number.
If you truly can concurrently use 10 cpus then do that. How many are needed for O/S and BackupServer stripes?

--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0

"rjlpedrosa" wrote in message news:4f4257dd.5fe3.1681692777@sybase.com...
> Dear all,
>
> I'm installing ASE 15.7 and I've a question about
> Hyperthreading.
> I'm using Intel(R) Xeon(R) CPU X5570 @ 2.93GHz with a total
> of 8 cores.
> However because hyperthreading is activated, linux (RedHat
> 5) recognizes 16 logical processes.
>
> My question is, using ASE 15.7 with a threaded kernel, will
> I have advantages on using hyperthreading?
> For the number of engines should I use the number of logic
> processes (for example 14 and leave 1 core for the OS) or
> should I base it on the number of cores (for example 7)?
>
> Thanks