SQL Anywhere database - Maximum reasonable size for ASA

Author

Maximum reasonable size for ASA

Stefan Lobet

2005-05-13, 9:23 am

Hi all

Our company is using SQL Remote replication between ASA at the remote sites
and ASE as a consolidated database in the head office. Because of the end
of life of SQL Remote for ASE later this year, we are looking at different
options for moving forward. One of these is migrating the consolidated
database to ASA. The question is, what is the performance of ASA like on
larger databases? Currently, our ASE consolidated is about 20GB, with the
largest tables having around 20 million rows. This is not huge, but I have
no experience on ASA with that kind of data.

All of our systems are running on Win2K boxes, with the consolidated DB on a
four-processor machine.

Opinions / experiences appreciated

Stefan Lobet

Nick Elson

2005-05-13, 9:23 am

We have had numerous customers running with databases of that
size.

Also, you can keep the ASE server and replace SQL Remote
with MobiLink.

Either solution is acceptable. How acceptable will depend upon
which works best for you.

"Stefan Lobet" <stephane.lobet@pretpret.com> wrote in message
news:4284a6a0$1@foru
ms-1-dub...
>
> Hi all
>
> Our company is using SQL Remote replication between ASA at the remote
> sites
> and ASE as a consolidated database in the head office. Because of the end
> of life of SQL Remote for ASE later this year, we are looking at different
> options for moving forward. One of these is migrating the consolidated
> database to ASA. The question is, what is the performance of ASA like on
> larger databases? Currently, our ASE consolidated is about 20GB, with the
> largest tables having around 20 million rows. This is not huge, but I
> have
> no experience on ASA with that kind of data.
>
> All of our systems are running on Win2K boxes, with the consolidated DB on
> a
> four-processor machine.
>
> Opinions / experiences appreciated
>
> Stefan Lobet
>
>

Andrei Iliev

2005-05-13, 9:23 am

20 Gb is not a problem. We have ASA DB > 100Gb in size.

Andrei Iliev

"Stefan Lobet" <stephane.lobet@pretpret.com> wrote in message
news:4284a6a0$1@foru
ms-1-dub...
>
> Hi all
>
> Our company is using SQL Remote replication between ASA at the remote
sites

> and ASE as a consolidated database in the head office. Because of the end
> of life of SQL Remote for ASE later this year, we are looking at different
> options for moving forward. One of these is migrating the consolidated
> database to ASA. The question is, what is the performance of ASA like on
> larger databases? Currently, our ASE consolidated is about 20GB, with the
> largest tables having around 20 million rows. This is not huge, but I
have
> no experience on ASA with that kind of data.
>
> All of our systems are running on Win2K boxes, with the consolidated DB on
a
> four-processor machine.
>
> Opinions / experiences appreciated
>
> Stefan Lobet
>
>

Reg Domaratzki $iAnywhere Solutions$

2005-05-13, 9:23 am

You may also want to consider moving to MobiLink. There's a on-line
whitepaper available here with some information on how that could be
accomplished : http://www.ianywhere.com/whitepaper...ate_to_ml.html.

IMHO, I believe it would be easier to migrate the consolidated to ASA and
continue to use SQL Remote, but you should at least look into using
MobiLink, as there are many benefits to using MobiLink over SQL Remote.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Stefan Lobet" <stephane.lobet@pretpret.com> wrote in message
news:4284a6a0$1@foru
ms-1-dub...
>
> Hi all
>
> Our company is using SQL Remote replication between ASA at the remote
sites

> and ASE as a consolidated database in the head office. Because of the end
> of life of SQL Remote for ASE later this year, we are looking at different
> options for moving forward. One of these is migrating the consolidated
> database to ASA. The question is, what is the performance of ASA like on
> larger databases? Currently, our ASE consolidated is about 20GB, with the
> largest tables having around 20 million rows. This is not huge, but I
have
> no experience on ASA with that kind of data.
>
> All of our systems are running on Win2K boxes, with the consolidated DB on
a
> four-processor machine.
>
> Opinions / experiences appreciated
>
> Stefan Lobet
>
>

Troy Coombs

2005-05-13, 11:23 am

Interesting....

How many concurrent users would you say is hitting your DB?

Troy

"Andrei Iliev" <xzxz@mail.ru> wrote in message
news:4284b617$1@foru
ms-1-dub...
> 20 Gb is not a problem. We have ASA DB > 100Gb in size.
>
> Andrei Iliev
>
> "Stefan Lobet" <stephane.lobet@pretpret.com> wrote in message
> news:4284a6a0$1@foru
ms-1-dub...
> sites
end[color=darkred]
different[color=dark
red]
on[color=darkred]
the[color=darkred]
> have
on[color=darkred]
> a
>
>

Stefan Lobet

2005-05-13, 11:23 am

Thanks people...
I've read the document and some Mobilink documentation as well. It looks
promising but quite challenging as well, we'd have to do quite a bit of work
on the consolidated. On the other hand, we could then move to Microsoft SQL
Server which everybody else in this company is keen on (tried to get them to
see the Linux light to no avail...:(
It just seems that moving the ASE to ASA might be less work, if ASA can pull
it off...

Thanks again
Stefan

"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
wrote in message news:4284ba61$1@foru
ms-1-dub...
> You may also want to consider moving to MobiLink. There's a on-line
> whitepaper available here with some information on how that could be
> accomplished : http://www.ianywhere.com/whitepaper...ate_to_ml.html.
>
> IMHO, I believe it would be easier to migrate the consolidated to ASA and
> continue to use SQL Remote, but you should at least look into using
> MobiLink, as there are many benefits to using MobiLink over SQL Remote.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> "Stefan Lobet" <stephane.lobet@pretpret.com> wrote in message
> news:4284a6a0$1@foru
ms-1-dub...
> sites
end[color=darkred]
different[color=dark
red]
on[color=darkred]
the[color=darkred]
> have
on[color=darkred]
> a
>
>

Greg Fenton

2005-05-14, 3:23 am

Stefan Lobet wrote:
> It just seems that moving the ASE to ASA might be less work, if ASA can pull
> it off...
>

ASA certainly can handle the size of database you are talking about.

As for concurrent users, take a look at this story:

http://www.ianywhere.com/press_rele...dec_sqlany.html

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

Andrei Iliev

2005-05-14, 9:24 am

Not so much. 1-2 inserting, updating, and 10-20 browsing.

"Troy Coombs" <coombst@quorumis.com> wrote in message
news:4284cf81$1@foru
ms-2-dub...
> Interesting....
>
> How many concurrent users would you say is hitting your DB?
>
> Troy
>
>
> "Andrei Iliev" <xzxz@mail.ru> wrote in message
> news:4284b617$1@foru
ms-1-dub...
> end
> different
consolidated[color=d
arkred]
> on
> the
DB[color=darkred]
> on
>
>

Sponsored Links