Is there any consideration when configuring services on the same server?

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!

sa-17 service server

asked 13 Jan '20, 20:02

JAValdez
45●2●2●7
accept rate: 0%

flat view

One Answer:

active answers oldest answers newest answers popular answers

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 Barth
40.2k●361●550●822
accept rate: 34%

Just to add:

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

Frequently asked questions - SQL Anywhere

(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

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "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

learn more about Markdown

Question tags:

sa-17 ×246
service ×40
server ×37

question asked: 13 Jan '20, 20:02

question was seen: 947 times

last updated: 14 Jan '20, 11:56

SAP SQL Anywhere

Is there any consideration when configuring services on the same server?

Follow this question

Related questions