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.

ASA scalability - any insight will be hightly appreciated

4 posts in General Discussion Last posting was on 2006-05-25 16:42:26.0Z
sye Posted on 2006-05-23 22:07:17.0Z
Sender: 4dc2.4473845a.1804289383@sybase.com
From: sye@imsi.com
Newsgroups: ianywhere.public.general
Subject: ASA scalability - any insight will be hightly appreciated
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44738733.4de2.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 23 May 2006 15:05:39 -0700, 10.22.241.42
Lines: 20
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 May 2006 15:05:41 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 May 2006 15:07:17 -0700
X-Trace: forums-1-dub 1148422037 10.22.108.75 (23 May 2006 15:07:17 -0700)
X-Original-Trace: 23 May 2006 15:07:17 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5371
Article PK: 1420

Hi,

One of my mission-critical application is currently running
on ASA 9.0.2.2451 on Windows 2003 server. I have 315 tables,
1200 stored procedures, 7 GB database, and 100 concurrent
users at peak time. I am expect our user and data to grow
25% annually.

The application performance is ok right now, but has
degraded over the time as data grow, and sometimes is very
slow at peak time.

I am advised to convert to either Sybase ASE or MS SQL
server to make sure the application scale well in the
future. I'd like to know if any shops has similar size
application running on ASA. Any benchmarks on how well ASA
scales against ASE or MS SQL on similar platform?

Thanks,
Susan Ye


"Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g Posted on 2006-05-24 00:28:09.0Z
From: "Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ASA scalability - any insight will be hightly appreciated
References: <44738733.4de2.1681692777@sybase.com>
In-Reply-To: <44738733.4de2.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
Message-ID: <4473a839@forums-2-dub>
X-Original-Trace: 23 May 2006 17:26:33 -0700, cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
Lines: 37
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 May 2006 17:26:35 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 May 2006 17:28:09 -0700
X-Trace: forums-1-dub 1148430489 10.22.108.75 (23 May 2006 17:28:09 -0700)
X-Original-Trace: 23 May 2006 17:28:09 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5372
Article PK: 1419

Here is an example of a system that exceeds your expected requirements:
http://www.ianywhere.com/press_releases/microdec_sqlany.html

You are nowhere near any limits of the engine. However, you may have a
poorly designed schema or application that would perform poorly hosted
against any database engine. You may want to determine where the system
is hitting bottlenecks and work those issues out. Simply moving to a
different engine may not solve the problems you are encountering. As a
starting point, look at the index consultant and the procedure profiling
tools to help you in your investigation. If you have narrowed the
problem to a specific set of queries, use the graphical query plan
w/statistics to determine if there are issues with the access plans for
those queries.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Breck Carter [Team iAnywhere] Posted on 2006-05-24 12:11:57.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: ASA scalability - any insight will be hightly appreciated
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <pvi872lpg1rk2e48nj804mmka7u5jk00ae@4ax.com>
References: <44738733.4de2.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 24 May 2006 05:10:17 -0700, bcarter.sentex.ca
Lines: 41
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 May 2006 05:10:19 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 May 2006 05:11:57 -0700
X-Trace: forums-1-dub 1148472717 10.22.108.75 (24 May 2006 05:11:57 -0700)
X-Original-Trace: 24 May 2006 05:11:57 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5375
Article PK: 1425

I agree with what Chris said... you are a very long way from any
unsolvable problems. Assuming your hardware choices keep up, at 25%
compound annual growth you will never, ever outgrow SQL Anywhere.
Plus, your costs will be much lower than with ASE or MSS or any of the
others: both software and wetware (that's you :)

In addition, you may be interested in Chapter 10 Tuning in my book.
The performance problems you are experiencing are almost certainly
solvable.

Breck

On 23 May 2006 15:07:17 -0700, sye@imsi.com wrote:

>Hi,
>
>One of my mission-critical application is currently running
>on ASA 9.0.2.2451 on Windows 2003 server. I have 315 tables,
>1200 stored procedures, 7 GB database, and 100 concurrent
>users at peak time. I am expect our user and data to grow
>25% annually.
>
>The application performance is ok right now, but has
>degraded over the time as data grow, and sometimes is very
>slow at peak time.
>
>I am advised to convert to either Sybase ASE or MS SQL
>server to make sure the application scale well in the
>future. I'd like to know if any shops has similar size
>application running on ASA. Any benchmarks on how well ASA
>scales against ASE or MS SQL on similar platform?
>
>Thanks,
>Susan Ye

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Justin Willey Posted on 2006-05-25 16:42:26.0Z
From: "Justin Willey" <gjw@nospamatall.iqx.co.uk>
Newsgroups: ianywhere.public.general
References: <44738733.4de2.1681692777@sybase.com>
Subject: Re: ASA scalability - any insight will be hightly appreciated
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: i-83-67-79-29.freedom2surf.net
Message-ID: <4475de07@forums-2-dub>
X-Original-Trace: 25 May 2006 09:40:39 -0700, i-83-67-79-29.freedom2surf.net
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 May 2006 09:40:41 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 May 2006 09:42:26 -0700
X-Trace: forums-1-dub 1148575346 10.22.108.75 (25 May 2006 09:42:26 -0700)
X-Original-Trace: 25 May 2006 09:42:26 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5389
Article PK: 1439

Hi

We have several clients with databases exceeding 20GB, some with 300+
concurrent users, with lots of complex logic held in database functions /
procedures etc who have good performance, even using ODBC over WANs.

Were we have had bottlenecks, we have been able to resolve them by improving
the database and query design.

Hardware can have a critical effect, particularly memory and disk speed eg
RAID 1+0 is generally far faster than RAID 5 in our experience, dual
processors can help a lot etc etc

Something else to look at is database fragmentation.

Justin Willey

<sye@imsi.com> wrote in message news:44738733.4de2.1681692777@sybase.com...
> Hi,
>
> One of my mission-critical application is currently running
> on ASA 9.0.2.2451 on Windows 2003 server. I have 315 tables,
> 1200 stored procedures, 7 GB database, and 100 concurrent
> users at peak time. I am expect our user and data to grow
> 25% annually.
>
> The application performance is ok right now, but has
> degraded over the time as data grow, and sometimes is very
> slow at peak time.
>
> I am advised to convert to either Sybase ASE or MS SQL
> server to make sure the application scale well in the
> future. I'd like to know if any shops has similar size
> application running on ASA. Any benchmarks on how well ASA
> scales against ASE or MS SQL on similar platform?
>
> Thanks,
> Susan Ye