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.

Thread pools configuration in ASE 15.7

2 posts in General Discussion Last posting was on 2012-03-06 09:14:11.0Z
rjlpedrosa Posted on 2012-03-06 06:45:30.0Z
Sender: 653f.4f55af6c.1804289383@sybase.com
From: rjlpedrosa
Newsgroups: sybase.public.ase.general
Subject: Thread pools configuration in ASE 15.7
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f55b28a.65d6.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 5 Mar 2012 22:45:30 -0800
X-Trace: forums-1-dub 1331016330 172.20.134.41 (5 Mar 2012 22:45:30 -0800)
X-Original-Trace: 5 Mar 2012 22:45:30 -0800, 172.20.134.41
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30983
Article PK: 73874

Hello,

I'm installing ASE 15.7 on new machines and I'm using the
default threaded kernel.
The machines have 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.

I have to do a base configuration even without knowing the
workload that will be used.
I've seen that I have 3 thread pools to configure (user,
system and blocking) instead of configuring the number of
engines.
The question is, has anyone already configured these pools
for a machine like the ones I'm using? What were the values
used?

At moment, I have increase the number of threads in the user
pool from 1 to 7. System has 3 and blocking has 4, so in
total I have 14 threads but this seems low to me. What
should be factors to use in the configuration? Connections
and cores? Any formula?

Thanks


Rob V Posted on 2012-03-06 09:14:11.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: Thread pools configuration in ASE 15.7
References: <4f55b28a.65d6.1681692777@sybase.com>
In-Reply-To: <4f55b28a.65d6.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: <4f55d563$1@forums-1-dub>
Date: 6 Mar 2012 01:14:11 -0800
X-Trace: forums-1-dub 1331025251 10.22.241.152 (6 Mar 2012 01:14:11 -0800)
X-Original-Trace: 6 Mar 2012 01:14:11 -0800, vip152.sybase.com
Lines: 48
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30984
Article PK: 73873


On 06-Mar-2012 07:45, rjlpedrosa wrote:
> Hello,
>
> I'm installing ASE 15.7 on new machines and I'm using the
> default threaded kernel.
> The machines have 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.
>
> I have to do a base configuration even without knowing the
> workload that will be used.
> I've seen that I have 3 thread pools to configure (user,
> system and blocking) instead of configuring the number of
> engines.
> The question is, has anyone already configured these pools
> for a machine like the ones I'm using? What were the values
> used?
>
> At moment, I have increase the number of threads in the user
> pool from 1 to 7. System has 3 and blocking has 4, so in
> total I have 14 threads but this seems low to me. What
> should be factors to use in the configuration? Connections
> and cores? Any formula?
>
> Thanks

Check out the 15.7 system admin guide;
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc31644.1570/html/sag2/X53199.htm

--
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
-----------------------------------------------------------------