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.

Engines configuration & max scan parallel degree

2 posts in Windows NT Last posting was on 2000-12-28 20:21:43.0Z
Puvendran Posted on 2000-12-28 04:35:39.0Z
From: "Puvendran" <Punvendran.selvaratnam@BTFinancialgroup.com>
Subject: Engines configuration & max scan parallel degree
Date: Thu, 28 Dec 2000 15:35:39 +1100
Lines: 17
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
Message-ID: <VLZoMnIcAHA.85@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: aupozx665.btal.com.au 203.10.111.3
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1363
Article PK: 1088828

Hi all,

In configuring "max scan parallel degree " I would expect for this
number to be at least 1 less than the available number of engines so that
any given process cannot flood all the available engines with it's worker
threads e.g

4 sybase engines should result in "max scan parallel degree " being set
to 3 or less.

Can anyone shed light on this please ?

Thanks

Puvendran


Bret Halford Posted on 2000-12-28 20:21:43.0Z
Message-ID: <3A4BA0D7.DEB2050C@sybase.com>
Date: Thu, 28 Dec 2000 13:21:43 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Engines configuration & max scan parallel degree
References: <VLZoMnIcAHA.85@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 24
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1361
Article PK: 1088826

Well, you might want to impose such limits on yourself, if you find that
such flooding is actually a problem on your system. However, ASE certainly
doesn't
impose such limits, it wouldn't make sense for all our users. (For instance,
a single-threaded nightly batch with no other activity on the server might want
this configuration higher than the number of engines, particularly if worker
processes
tend to need to wait on physical IO).

-bret

Puvendran wrote:

> Hi all,
>
> In configuring "max scan parallel degree " I would expect for this
> number to be at least 1 less than the available number of engines so that
> any given process cannot flood all the available engines with it's worker
> threads e.g
>
> 4 sybase engines should result in "max scan parallel degree " being set
> to 3 or less.
>
> Can anyone shed light on this please ?
>
> Thanks
>
> Puvendran