Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

SaaS hosting physical server will have about 3000-5000 customers with separate database per each. Will ASA have any perfomance problems to serve simultaniosly such volume of database with active users?

asked 28 Sep '11, 18:34

s_tristan's gravatar image

accept rate: 0%

edited 23 Aug '12, 07:28

Justin%20Willey's gravatar image

Justin Willey

SQL Anywhere servers are limited to 255 databases per server instance as an upper bound; obviously the number of databases that can be supported on a single server depends on the workload and on the system configuration (ie hardware, whether or not multiple servers are competing for resources on the same machine, etc).

SQL Anywhere's On Demand Edition (codenamed "Fuji"), as Volker pointed out, is intended to help solve these deployment issues by offering tools with which to manage a large number of servers and individual databases as a whole. I would encourage you to look at Fuji when it is released for Beta (soon) and join our Beta program.

permanent link

answered 29 Sep '11, 06:59

Glenn%20Paulley's gravatar image

Glenn Paulley
accept rate: 43%

To clarify, as one machine can run several database server instances:

Is there a technical limit as to the number of database engines on one physical server, i.e. could one machine run 200 database engines each running 250 databases thus running 5000 databases in total?

(I don't suggest this would be a sensible thing to do...)

(29 Sep '11, 07:20) Volker Barth
Replies hidden

soon can be Oct/2011?

(29 Sep '11, 10:15) Zote
Replies hidden

Is there a technical limit as to the number of database engines on one physical server?

No, you're only limited by the total OS memory constraints for all of the database servers in this scenario. Eventually you will get into a situation where we can't allocate all of the database start-up cache/worker threads (due to lack of resources) on one of the database servers.

(29 Sep '11, 16:40) Jeff Albion

Yes. From:

"Fuji" is the codename of the first release of SQL Anywhere OnDemand Edition. The "Fuji" Beta program is open for pre-registration. By pre-registering, we will send you a notification email when the Beta software become available for download. The software is expected to be available by October 2011.

Pre-Register for SQL Anywhere OnDemand Edition "Fuji" Beta Program

(29 Sep '11, 16:42) Jeff Albion

does you plan to run all 5000 db's under one database server instance? Personally I am don't think that it's a good idea. I don't know real correct answer about SA kernel, but for starting databases you must also consider command line length limitations in windwows cmd.exe or linux bash shells.

In windows cmd.exe it limit to 8191 character.

In linux look at:

permanent link

answered 29 Sep '11, 02:57

AlexeyK77's gravatar image

accept rate: 8%

Well, you can also start databases on a running server with the START DATABASE command, so the OS command line length is not necessarily a restriction (the mere database number might be...)

(29 Sep '11, 03:31) Volker Barth

Also, if DB server crush, than all your customer databases also crush together at one moment. Good pattern - don't put all eggs at one basket.

(29 Sep '11, 03:46) AlexeyK77

You can list all the databases and server switches in a file, say "server.cfg", and then start the server with "dbsrv12 @server.cfg". The server.cfg file can be as big as you want.

(29 Sep '11, 21:05) Graeme Perrow

Besides the typical answer "It depends" - as one will need much more information on expected number of requests, transaction volume, database sizes and the like to give any hint:

This sound like you're looking for Fuji, the upcoming "SQL Anywhere for the cloud solution"...

I have just read some press releases, and the beta is expected in the next weeks, so I can't tell more (but the Sybase folks can, for sure...)

permanent link

answered 29 Sep '11, 03:36

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

edited 29 Sep '11, 07:45

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 28 Sep '11, 18:34

question was seen: 3,113 times

last updated: 23 Aug '12, 07:28