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.

Uni-to-Multi processor...

2 posts in Windows NT Last posting was on 1998-05-08 08:44:29.0Z
Rob Ratterman Posted on 1998-05-08 03:56:08.0Z
From: "Rob Ratterman" <jump@goodnews.net>
Subject: Uni-to-Multi processor...
Date: Thu, 7 May 1998 23:56:08 -0400
Lines: 16
Organization: Jump Inc.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <AOmdUuie9GA.154@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:5032
Article PK: 1092396

Hi!

We currently have Sybase System XI on a 300mhz Pentium II box with 128mb
ram. The motherboard is dual PII capable, although we currently have only
one CPU installed.

What issues need to be considered when upgrading to a dual-processor system?
Considering we get NT to recognize the second processor OK, will Sybase just
start using "automatically?" Should we change the number of engines, etc?

Thanks for your thoughts!

Rob


Tony Imbierski Posted on 1998-05-08 08:44:29.0Z
Message-ID: <3552C5ED.435F@sybase.com>
Date: Fri, 08 May 1998 09:44:29 +0100
From: Tony Imbierski <tonyi@sybase.com>
Reply-To: tonyi@sybase.com
Organization: Sybase Adaptive Server Engineering
X-Mailer: Mozilla 3.02 (WinNT; I)
MIME-Version: 1.0
Subject: Re: Uni-to-Multi processor...
References: <AOmdUuie9GA.154@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 36
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5031
Article PK: 1092395


Rob Ratterman wrote:
>
> Hi!
>
> We currently have Sybase System XI on a 300mhz Pentium II box with 128mb
> ram. The motherboard is dual PII capable, although we currently have only
> one CPU installed.
>
> What issues need to be considered when upgrading to a dual-processor system?
> Considering we get NT to recognize the second processor OK, will Sybase just
> start using "automatically?" Should we change the number of engines, etc?
>
> Thanks for your thoughts!
>
> Rob

Hi Rob,

Sybase will remain as a single-engine system until you reconfigure. This
means only one database task will execute at a time, using one of the
cpu's (though it could be either one). However you will still see a
performance boost because other threads (including NT system tasks) will
not be competing with the sybase engine for the single CPU as they
currently do. If you reconfigure to run 2 engines, then database tasks
will be able to run in parallel using both cpu's.

For more advice on choosing the right number of engines, see the
Performance and Tuning guide.

cheers,
tonyi
--
===============================================================
Tony Imbierski
Sybase Adaptive Server Engineering
Kernel & Platform Sustaining
---------------------------------------------------------------

===============================================================