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.

Many instances of Sybase

3 posts in Windows NT Last posting was on 2001-03-21 04:06:49.0Z
Ramesh_Ramamurthy Posted on 2001-02-20 10:54:40.0Z
From: Ramesh_Ramamurthy
Date: Tue, 20 Feb 2001 05:54:40 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Many instances of Sybase
Message-ID: <B9E3C390C6B2D3E9003BF006852569F9.003BF019852569F9@webforums>
Lines: 17
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1200
Article PK: 1088678

Hi All,

We have a data model wherein we use one common database for storing all the
stored procedures and tables which have only referential data, and
different databases for storing tables with OLTP according to the client.
That is, there will be one database per client referring to a common
database for executing the stored procedures and for referring to
referential data.

In this scenario, we want to use a server with 8 CPUs and 2 GB ram, and
create two instances of Sybase each of them with 4 engines each bound to
one CPU.

Is this kind of design viable?

Request your valuable suggestions and criticism.

Regards
Ramesh


Puvendran Posted on 2001-03-21 04:06:49.0Z
From: "Puvendran" <Punvendran.selvaratnam@BTFinancialgroup.com>
References: <B9E3C390C6B2D3E9003BF006852569F9.003BF019852569F9@webforums>
Subject: Re: Many instances of Sybase
Date: Wed, 21 Mar 2001 15:06:49 +1100
Lines: 41
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
Message-ID: <4Tme17bsAHA.198@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: aupozx665.btal.com.au 203.10.111.3
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1054
Article PK: 1087659

Hi Ramesh,

Is there a limit on the number of engines an ASE server can support. If not,
can a single server be considered ? However, this approach does have the
drawback of all applications being affected by changes/downtime on that one
server.

I would have thought by tying each engine to a CPU you are unnecessarily
restricting use of CPU's.

Also, if you are not aware ASE does offer concept of application queues with
different levels of priority for each queue, and which can be user defined.
This may also help you assign different tasks to the various queues
depending on priority.

Hope this helps

Puvendran

Ramesh_Ramamurthy wrote in message ...
>Hi All,
>
>We have a data model wherein we use one common database for storing all the
>stored procedures and tables which have only referential data, and
>different databases for storing tables with OLTP according to the client.
>That is, there will be one database per client referring to a common
>database for executing the stored procedures and for referring to
>referential data.
>
>In this scenario, we want to use a server with 8 CPUs and 2 GB ram, and
>create two instances of Sybase each of them with 4 engines each bound to
>one CPU.
>
>Is this kind of design viable?
>
>Request your valuable suggestions and criticism.
>
>Regards
>Ramesh


Jim Egan Posted on 2001-03-16 05:13:09.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: Many instances of Sybase
Date: Thu, 15 Mar 2001 22:13:09 -0700
Message-ID: <MPG.151b4ed0ef7982d998b1b9@forums.sybase.com>
References: <B9E3C390C6B2D3E9003BF006852569F9.003BF019852569F9@webforums>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.30
Newsgroups: sybase.public.sqlserver.nt
Lines: 9
NNTP-Posting-Host: c1420400-b.hiland1.co.home.com 65.7.153.228
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1083
Article PK: 1087685

My initial thought is that I wouldn't do it this way. Too much complexity, too many
databases. But, every situation is different and your requirements may be such that the
design is necessary.
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com