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 Server Instances

2 posts in General Discussion Last posting was on 2005-06-03 17:18:19.0Z
Jim Diaz Posted on 2005-06-03 17:08:31.0Z
From: "Jim Diaz" <jimdiazatemprisecorporationdotcom>
Newsgroups: ianywhere.public.general
Subject: Multiple Server Instances
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.1830
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 209.182.73.66
X-Original-NNTP-Posting-Host: 209.182.73.66
Message-ID: <42a08e8f$1@forums-1-dub>
Date: 3 Jun 2005 10:08:31 -0700
X-Trace: forums-1-dub 1117818511 209.182.73.66 (3 Jun 2005 10:08:31 -0700)
X-Original-Trace: 3 Jun 2005 10:08:31 -0700, 209.182.73.66
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4531
Article PK: 8340

Would it ever make sence to run multiple Sybase ASA 9.02.2551 instances on
the same hardware platform rather than one instance with multiple databases
(assuming the hardware configuration was a constant)? Would the overall
performance always be better with a single instance and multiple databases?
Logically I would say yes.

I suppose if you want to control the resources provided to a single
database, than more than one server instance would provide this flexability,
when a single instance would not.


Thanks

Jim


Greg Fenton Posted on 2005-06-03 17:18:19.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Multiple Server Instances
References: <42a08e8f$1@forums-1-dub>
In-Reply-To: <42a08e8f$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: gfenton-t30.sybase.com
Message-ID: <42a090d6$1@forums-2-dub>
X-Original-Trace: 3 Jun 2005 10:18:14 -0700, gfenton-t30.sybase.com
Lines: 27
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Jun 2005 10:18:16 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Jun 2005 10:18:19 -0700
X-Trace: forums-1-dub 1117819099 10.22.108.75 (3 Jun 2005 10:18:19 -0700)
X-Original-Trace: 3 Jun 2005 10:18:19 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4532
Article PK: 8341


Jim Diaz wrote:
> Would it ever make sence to run multiple Sybase ASA 9.02.2551 instances on
> the same hardware platform rather than one instance with multiple databases
> (assuming the hardware configuration was a constant)?

Yes. If your applications had particular server settings for their
respsective database, but those settings were incompatible, then running
separate servers would make sense.

> Would the overall
> performance always be better with a single instance and multiple databases?
>

Mostly yes, except that the server may not be making the most optimal
use of those resources. For example, if one .db had a 2K page size and
another has a 4K page size, then the server's cache will use a 4K page
size and pages from the first database will not be making full use of
its cache.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/