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.

Multiple processors and multiple database engines

3 posts in Windows NT Last posting was on 1997-11-30 18:47:14.0Z
Chris Steains Posted on 1997-11-28 11:55:44.0Z
Subject: Multiple processors and multiple database engines
From: cls@intravel.com.au (Chris Steains)
Organization: Internet Travel
X-Newsreader: WinVN 0.99.9 (Beta 3) (x86 32bit)
MIME-Version: 1.0
Content-Type: Text/Plain; charset=US-ASCII
Message-ID: <ZAniOS$#8GA.132@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Date: Fri, 28 Nov 1997 06:55:44 -0500
Lines: 15
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5384
Article PK: 1081464

I guess this question has been asked a million times...but... if I have an
NT4.0 system with 4 processors, how many database engines are best to configure
for SQL Server (System11)? The Sybase documentation seems to contradict itself
- one document will say to set the number of engines to equal the number of
CPU's, another document will say set the number of engines to 1 less than the
number of CPU's (reserving one for the operating system). Is there actually a
definitive answer??

Chris Steains
Internet Travel
cls@intravel.com.au


Gary Kuever Posted on 1997-11-28 15:38:54.0Z
From: "Gary Kuever" <gkuever@ix.netcom.com>
References: <ZAniOS$#8GA.132@forums.powersoft.com>
Subject: Re: Multiple processors and multiple database engines
Date: Fri, 28 Nov 1997 07:38:54 -0800
Lines: 18
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-Mimeole: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <6Yhb6qA$8GA.77@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5383
Article PK: 1081477

The datum I use on UNIX is if Sybase is the ONLY thing being done on the
box, then use number=number of engines. If anything else like reports,
compiles, etc. run then use engines = engines minus 1.

I'd take a look at how many services are running on the NT box, if any will
be added over time and go from there.
Gary

>- one document will say to set the number of engines to equal the number of
>CPU's, another document will say set the number of engines to 1 less than
the
>number of CPU's (reserving one for the operating system). Is there
actually a
>definitive answer??


Chris Steains Posted on 1997-11-30 18:47:14.0Z
Subject: Re: Multiple processors and multiple database engines
From: cls@intravel.com.au (Chris Steains)
Organization: Internet Travel
X-Newsreader: WinVN 0.99.9 (Beta 3) (x86 32bit)
References: <ZAniOS$#8GA.132@forums.powersoft.com> <6Yhb6qA$8GA.77@forums.powersoft.com>
MIME-Version: 1.0
Content-Type: Text/Plain; charset=US-ASCII
Message-ID: <dGw8fBc$8GA.132@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Date: Sun, 30 Nov 1997 13:47:14 -0500
Lines: 19
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5381
Article PK: 1081443

In article <6Yhb6qA$8GA.77@forums.powersoft.com>, gkuever@ix.netcom.com says...

>
>The datum I use on UNIX is if Sybase is the ONLY thing being done on the
>box, then use number=number of engines. If anything else like reports,
>compiles, etc. run then use engines = engines minus 1.
>
>I'd take a look at how many services are running on the NT box, if any will
>be added over time and go from there.
>Gary
>
>
>>- one document will say to set the number of engines to equal the number of
>>CPU's, another document will say set the number of engines to 1 less than
>the
>>number of CPU's (reserving one for the operating system). Is there
>actually a
>>definitive answer??
>
>
>

Yeh, thanks, that makes sense.

Chris Steains