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!
Subject: Uni-to-Multi processor...
Date: Thu, 7 May 1998 23:56:08 -0400
Organization: Jump Inc.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Xref: forums-1-dub sybase.public.sqlserver.nt:5032
Article PK: 1092396
Date: Fri, 08 May 1998 09:44:29 +0100
From: Tony Imbierski <firstname.lastname@example.org>
Organization: Sybase Adaptive Server Engineering
X-Mailer: Mozilla 3.02 (WinNT; I)
Subject: Re: Uni-to-Multi processor...
Content-Type: text/plain; charset=us-ascii
Xref: forums-1-dub sybase.public.sqlserver.nt:5031
Article PK: 1092395
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.
Sybase Adaptive Server Engineering
Kernel & Platform Sustaining