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.

How Much Is Too Much For ASA8/9

4 posts in General Discussion Last posting was on 2003-10-07 13:03:31.0Z
AKhan Posted on 2003-09-17 14:32:46.0Z
Sender: 45d5.3f686f08.1804289383@sybase.com
From: Akhan
Newsgroups: ianywhere.public.general
Subject: How Much Is Too Much For ASA8/9
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f68708e.45f7.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Sep 2003 07:32:46 -0700
X-Trace: forums-1-dub 1063809166 10.22.241.41 (17 Sep 2003 07:32:46 -0700)
X-Original-Trace: 17 Sep 2003 07:32:46 -0700, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1765
Article PK: 4058

My Company is thinking of going to ASA8, they have databases
with the largest one around 35Gig. Initial user load is
supposed to be around 300-500 users but it may grow to be a
couple of thousand. Can ASA handle this kind of load, how
can I compare ASA with ASE, what tests will show good
comparisons. I have checked out the trantest and it gives
you T/sec, min response time, max response time, etc. But
how can I tell that 50 Transaction is a good performance.
Does any one know what is the T/sec rate for ASE? I realize
that these are a lot questions, but the matter is just as
much confusing, any help would be greatly appreciated!


Graham Hurst Posted on 2003-10-06 14:25:04.0Z
From: Graham Hurst <spam_guard_hurst@ianywhere.com>
Organization: iAnywhere Solutions
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5b) Gecko/20030901 Thunderbird/0.2
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: How Much Is Too Much For ASA8/9
References: <3f68708e.45f7.846930886@sybase.com>
In-Reply-To: <3f68708e.45f7.846930886@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: hurst-xp.sybase.com
Message-ID: <3f817c02$1@forums-2-dub>
X-Original-Trace: 6 Oct 2003 07:28:18 -0700, hurst-xp.sybase.com
Lines: 21
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 6 Oct 2003 07:19:41 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 6 Oct 2003 07:25:04 -0700
X-Trace: forums-1-dub 1065450304 10.22.108.75 (6 Oct 2003 07:25:04 -0700)
X-Original-Trace: 6 Oct 2003 07:25:04 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1829
Article PK: 17371

This sort of load should pose no problem for 8.0.2 or 9.0.0, though as
always "it depends" on what the users are actually doing. We have many
customers using 50Gb or larger databases. We have also done some
performance benchmarking for a UK customer with two scenarios, an 18Gb
database with 1300 users (3900 concurrent connections) and another with
a database of 50Gb. Our in-lab testing uses databases of all sizes, up
to 100Gb of raw data (about 250Gb of database files).

Akhan wrote:
> My Company is thinking of going to ASA8, they have databases
> with the largest one around 35Gig. Initial user load is
> supposed to be around 300-500 users but it may grow to be a
> couple of thousand. Can ASA handle this kind of load, how
> can I compare ASA with ASE, what tests will show good
> comparisons. I have checked out the trantest and it gives
> you T/sec, min response time, max response time, etc. But
> how can I tell that 50 Transaction is a good performance.
> Does any one know what is the T/sec rate for ASE? I realize
> that these are a lot questions, but the matter is just as
> much confusing, any help would be greatly appreciated!


Piter Posted on 2003-10-07 06:57:31.0Z
From: "Piter" <piter@piter.pi>
Newsgroups: ianywhere.public.general
References: <3f68708e.45f7.846930886@sybase.com> <3f817c02$1@forums-2-dub>
Subject: Re: How Much Is Too Much For ASA8/9
Lines: 31
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
X-Original-NNTP-Posting-Host: vpn-uk-014.sybase.com
Message-ID: <3f82649c@forums-2-dub>
X-Original-Trace: 7 Oct 2003 00:00:44 -0700, vpn-uk-014.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 6 Oct 2003 23:52:02 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 6 Oct 2003 23:57:31 -0700
X-Trace: forums-1-dub 1065509851 10.22.108.75 (6 Oct 2003 23:57:31 -0700)
X-Original-Trace: 6 Oct 2003 23:57:31 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1830
Article PK: 4093

What was recommended hardware and OS for this customer in UK to handle
described task?

Thank you in advance for your comments.

Pit

"Graham Hurst" <spam_guard_hurst@ianywhere.com> wrote in message
news:3f817c02$1@forums-2-dub...
> This sort of load should pose no problem for 8.0.2 or 9.0.0, though as
> always "it depends" on what the users are actually doing. We have many
> customers using 50Gb or larger databases. We have also done some
> performance benchmarking for a UK customer with two scenarios, an 18Gb
> database with 1300 users (3900 concurrent connections) and another with
> a database of 50Gb. Our in-lab testing uses databases of all sizes, up
> to 100Gb of raw data (about 250Gb of database files).
>
> Akhan wrote:
> > My Company is thinking of going to ASA8, they have databases
> > with the largest one around 35Gig. Initial user load is
> > supposed to be around 300-500 users but it may grow to be a
> > couple of thousand. Can ASA handle this kind of load, how
> > can I compare ASA with ASE, what tests will show good
> > comparisons. I have checked out the trantest and it gives
> > you T/sec, min response time, max response time, etc. But
> > how can I tell that 50 Transaction is a good performance.
> > Does any one know what is the T/sec rate for ASE? I realize
> > that these are a lot questions, but the matter is just as
> > much confusing, any help would be greatly appreciated!
>


Glenn Paulley Posted on 2003-10-07 13:03:31.0Z
From: Glenn Paulley <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: iAnywhere Solutions
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: How Much Is Too Much For ASA8/9
References: <3f68708e.45f7.846930886@sybase.com> <3f817c02$1@forums-2-dub> <3f82649c@forums-2-dub>
In-Reply-To: <3f82649c@forums-2-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: paulley-xp.sybase.com
X-Original-NNTP-Posting-Host: paulley-xp.sybase.com
Message-ID: <3f82b9a3$1@forums-1-dub>
Date: 7 Oct 2003 06:03:31 -0700
X-Trace: forums-1-dub 1065531811 172.31.142.134 (7 Oct 2003 06:03:31 -0700)
X-Original-Trace: 7 Oct 2003 06:03:31 -0700, paulley-xp.sybase.com
Lines: 67
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1831
Article PK: 17391

That particular customer ran on a 4-way IBM 360 e-series server running
Windows 2000 server, utilizing an IBM RAID disk array. Database cache
was 2.3 Gb (the maximum without enabling AWE). Both the CPU and disk
subsystem were recommended by IBM engineers, though in our experiments
the need for a RAID array was marginal since the cache was large enough
to accomodate most of the application's working set, and hence there was
not enough I/O (once the cache was warm) to justify RAID hardware.

I repeat Graham's comment that it is dangerous to extrapolate from these
results to how ASA will perform with your application. I highly
recommend some detailed capacity planning (in a test environment) to
ensure that your computing environment is suitable for your
application's requirements.

Glenn

Piter wrote:
> What was recommended hardware and OS for this customer in UK to handle
> described task?
>
> Thank you in advance for your comments.
>
> Pit
> "Graham Hurst" <spam_guard_hurst@ianywhere.com> wrote in message
> news:3f817c02$1@forums-2-dub...
>
>>This sort of load should pose no problem for 8.0.2 or 9.0.0, though as
>>always "it depends" on what the users are actually doing. We have many
>>customers using 50Gb or larger databases. We have also done some
>>performance benchmarking for a UK customer with two scenarios, an 18Gb
>>database with 1300 users (3900 concurrent connections) and another with
>>a database of 50Gb. Our in-lab testing uses databases of all sizes, up
>>to 100Gb of raw data (about 250Gb of database files).
>>
>>Akhan wrote:
>>
>>>My Company is thinking of going to ASA8, they have databases
>>>with the largest one around 35Gig. Initial user load is
>>>supposed to be around 300-500 users but it may grow to be a
>>>couple of thousand. Can ASA handle this kind of load, how
>>>can I compare ASA with ASE, what tests will show good
>>>comparisons. I have checked out the trantest and it gives
>>>you T/sec, min response time, max response time, etc. But
>>>how can I tell that 50 Transaction is a good performance.
>>>Does any one know what is the T/sec rate for ASE? I realize
>>>that these are a lot questions, but the matter is just as
>>>much confusing, any help would be greatly appreciated!
>>
>
>

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer