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.

Hardware query

3 posts in General Discussion Last posting was on 2003-11-10 15:02:17.0Z
SIMON OGDEN Posted on 2003-11-06 12:41:35.0Z
From: "SIMON OGDEN" <simon.ogden@softbrands.com>
Newsgroups: ianywhere.public.general
Subject: Hardware query
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: softbrands.co.uk
X-Original-NNTP-Posting-Host: softbrands.co.uk
Message-ID: <3faa417f@forums-1-dub>
Date: 6 Nov 2003 04:41:35 -0800
X-Trace: forums-1-dub 1068122495 62.254.199.125 (6 Nov 2003 04:41:35 -0800)
X-Original-Trace: 6 Nov 2003 04:41:35 -0800, softbrands.co.uk
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2033
Article PK: 4250

Hi,

As a general query, could someone supply me with a rough estimate on the
recommended hardware to run the consolidated database for the following
setup.

A Powerbuilder 6.5 application running as follows.

A consolidated database, with 30-40 local users, using a 1 Gbit network,
running Windows NT and ASA 6.04

14 remote sites, replicating two-way continuously using file message type
(around 2000 messages per day per remote user) and dbremote, each remote
site has around 10-20 users.

The consolidated database is 2.5Gb, and consists of around 150 tables, all
keyed and indexed accordingly.

Application activity is for around 15 hours per day continously


I know these are not substantial details, but a rough guess would be
appreciated.

Thanks

Simon Ogden


Greg Fenton Posted on 2003-11-07 17:49:18.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4; MultiZilla v1.4.0.4A) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Hardware query
References: <3faa417f@forums-1-dub>
In-Reply-To: <3faa417f@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <3fabdc55$1@forums-2-dub>
X-Original-Trace: 7 Nov 2003 09:54:29 -0800, gfenton-xp.sybase.com
Lines: 42
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 7 Nov 2003 09:40:47 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 7 Nov 2003 09:49:18 -0800
X-Trace: forums-1-dub 1068227358 10.22.108.75 (7 Nov 2003 09:49:18 -0800)
X-Original-Trace: 7 Nov 2003 09:49:18 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2045
Article PK: 4264


SIMON OGDEN wrote:
>
> As a general query, could someone supply me with a rough estimate on the
> recommended hardware to run the consolidated database for the following
> setup.
>

I really don't know how to answer this. You've given a number of
details about your configuration, but there are at least a few other you
would need to provide:

- how much of the 2.5Gb is "active" data (i.e. being accessed
regularily)?
- what kind of setup do you currently have?
- what are the problems with the current setup?
- what constitutes acceptible behaviour?

The last question is, IMO, the most important and yet often the least
appreciated.

Obviously the more iron you throw at the problem, the better performance
*potential* you will have. But even running on a super-computer, your
database can be brought to a grinding halt by poorly written queries
and/or improperly designed schema.

I know that there are some people who throw out estimates on cache sizes
based on database file sizes, etc...but those are just generalizations.
Typically, the more memory, the faster CPU and faster disks, the
better. Also, consider using a RAID 0+1 disk configuration for speed
and reliability.

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


SIMON OGDEN Posted on 2003-11-10 15:02:17.0Z
From: "SIMON OGDEN" <simon.ogden@softbrands.com>
Newsgroups: ianywhere.public.general
References: <3faa417f@forums-1-dub> <3fabdc55$1@forums-2-dub>
Subject: Re: Hardware query
Lines: 52
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: softbrands.co.uk
X-Original-NNTP-Posting-Host: softbrands.co.uk
Message-ID: <3fafa879@forums-1-dub>
Date: 10 Nov 2003 07:02:17 -0800
X-Trace: forums-1-dub 1068476537 62.254.199.125 (10 Nov 2003 07:02:17 -0800)
X-Original-Trace: 10 Nov 2003 07:02:17 -0800, softbrands.co.uk
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2052
Article PK: 4269

It was only asking a rough guideline Greg, so take it as a very well
designed application with 90% of the databases in active usage.

Thanks

"Greg Fenton" <greg.fenton_NOSPAM_@ianywhere.com> wrote in message
news:3fabdc55$1@forums-2-dub...
> SIMON OGDEN wrote:
> >
> > As a general query, could someone supply me with a rough estimate on the
> > recommended hardware to run the consolidated database for the following
> > setup.
> >
>
> I really don't know how to answer this. You've given a number of
> details about your configuration, but there are at least a few other you
> would need to provide:
>
> - how much of the 2.5Gb is "active" data (i.e. being accessed
> regularily)?
> - what kind of setup do you currently have?
> - what are the problems with the current setup?
> - what constitutes acceptible behaviour?
>
> The last question is, IMO, the most important and yet often the least
> appreciated.
>
> Obviously the more iron you throw at the problem, the better performance
> *potential* you will have. But even running on a super-computer, your
> database can be brought to a grinding halt by poorly written queries
> and/or improperly designed schema.
>
> I know that there are some people who throw out estimates on cache sizes
> based on database file sizes, etc...but those are just generalizations.
> Typically, the more memory, the faster CPU and faster disks, the
> better. Also, consider using a RAID 0+1 disk configuration for speed
> and reliability.
>
> Hope this helps,
> greg.fenton
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
>