ASA perfomance in SaaS infrastructure

[Former Member]

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?

[Former Member]

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.

[VolkerBarth]

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...)

[Former Member]

soon can be Oct/2011?

[jeff_albion]

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.

[jeff_albion]

Yes. From: http://www.sybase.com/fujibeta

"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

[VolkerBarth]

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...)

[Former Member]

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: http://www.cyberciti.biz/faq/argument-list-too-long-error-solution/

[VolkerBarth]

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...)

[Former Member]

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.

[graeme_perrow]

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.