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
4 sybase engines should result in "max scan parallel degree " being set
to 3 or less.
Can anyone shed light on this please ?
Subject: Engines configuration & max scan parallel degree
Date: Thu, 28 Dec 2000 15:35:39 +1100
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
NNTP-Posting-Host: aupozx665.btal.com.au 188.8.131.52
Xref: forums-1-dub sybase.public.sqlserver.nt:1363
Article PK: 1088828
Date: Thu, 28 Dec 2000 13:21:43 -0700
From: Bret Halford <firstname.lastname@example.org>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
Subject: Re: Engines configuration & max scan parallel degree
Content-Type: text/plain; charset=us-ascii
NNTP-Posting-Host: bret-pc.sybase.com 184.108.40.206
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
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
tend to need to wait on physical IO).