Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

Hello everyone, my question is related to the configuration of the service on Anywhere 17. By having 20 databases, is there a difference in server performance if I define a single service that contains all the databases against sharing them in several services?

Thanks a lot!

asked 13 Jan '20, 20:02

JAValdez's gravatar image

accept rate: 0%

Here's an older discussion on that topic with different point of views.

To add a few points:

  • One server instance can better share its cache between many databases whereas 20 different server instances must restrict theis cache usage or will compete for RAM.
  • Each server instance will need its own port, whereas one server can use the default one.
  • With v16 and above, a former disadvantage of one single server instance is gone: A database assertion failure within one database does not affect other databases on the same instance. With v12 and below, it would stop all databases.

But in my understanding, this is not only a question of performance but with general maintenace. Say, you plan to upgrade the system. Is is fine for you to upgrade all databases at the same time? If not, several server instances might be more appropriate.

permanent link

answered 14 Jan '20, 03:56

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

Just to add:

For v16, this is also mentioned in the Online Help as part of the FAQ:

(14 Jan '20, 10:24) Volker Barth

Thanks Volker for your help!. I have read the links you recommended and I discuss it with my colleagues.

(14 Jan '20, 11:56) JAValdez
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: 13 Jan '20, 20:02

question was seen: 1,054 times

last updated: 14 Jan '20, 11:56