The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Over time, the functionality of dbeng and dbsrv has been drifting apart. In Version 12, for example, the new dynamic multiprogramming level (-gn) tuning feature is disabled in the personal server.

That difference is NOT listed in the "Server differences" Help topic http://dcx.sybase.com/index.html#1200en/dbadmin/da-running.html

Are there any others?

This is an important question since a SQL Anywhere engine can be run in standalone mode (one or zero actual client connections) but can still have extreme performance requirements; e.g., many simultaneous internal connections from events and services, many batch-style queries, and so on. The choice between dbeng and dbsrv is NOT necessarily a choice between "personal" and "network"... not any longer, not with the feature drift.

...or is the answer, "Always run dbsrv unless you have a good reason to run dbeng"?


Here's another difference, not performance-related: The default permissions required to stop the server using dbstop are different: dbeng -gk all versus dbsrv -gk DBA.

asked 22 Sep '10, 08:40

Breck%20Carter's gravatar image

Breck Carter
26.6k418575824
accept rate: 21%

edited 22 Sep '10, 20:04

Volker%20Barth's gravatar image

Volker Barth
29.3k287438644

Added a "documentation" tag - hopes it makes sense for answers that help to complete the official docs.

(22 Sep '10, 20:05) Volker Barth

I'm gonna leave tagging to other people... I keep coming up blank :)

(22 Sep '10, 21:01) Breck Carter

This is not (yet) an exhaustive list - I will add to it when needed.

Personal server

  • unsupported on Windows Mobile
  • no more than 10 simultaneous connections
  • limited to single CPU
  • the following features are not supported:
    • network communications
    • database mirroring
    • IP address monitoring My mistake - this is supported on both personal and network servers
    • communication packet compression
    • multiprogramming level tuning
    • registering the server with LDAP
  • only supports shared memory connections by default. You must specify -x tcpip to allow TCP/IP connections (only true for v12+)
  • gd server option defaults to all
  • gk server option defaults to all
  • gt server option defaults to 1
  • CHECKPOINT statement is allowed by all users
  • if the -su server switch is not specified, the utility_db has no password (any will work)
  • the following server switches are unsupported:
    • gn (initial number of concurrent server requests)
    • gna (disable auto resizing of request task pool)
    • gnh (maximum number of concurrent server requests)
    • gnl (minimum number of concurrent server requests)
    • gns (display multiprogramming level statistics)
    • pc (compress communication packets)
    • pt (set compression threshold)
    • sm (alternate mirror server name)
    • sn (alternate server name)
    • wc enable/disable checksums on writes
    • xa (arbiter mirroring options)
    • xf (database mirror state file)
    • xm (IP address monitoring)
    • xp database mirroring options

Network server

  • number of connections limited by your license
  • number of CPUs depends on license
  • gd server option defaults to DBA
  • gk server option defaults to DBA
  • gt server option defaults to number of licensed processors
  • allows both shared memory and TCP/IP connections by default
  • CHECKPOINT statement requires DBA authority
  • if the -su server switch is not specified, there must be a util_db.ini file containing the utility_db password, otherwise the utility_db is not accessible
permanent link

answered 22 Sep '10, 13:07

Graeme%20Perrow's gravatar image

Graeme Perrow
8.3k369106
accept rate: 51%

edited 08 Nov '10, 15:17

Please provide this great piece of information to the DCX team...

(22 Sep '10, 20:34) Volker Barth
4

I actually got it from the DCX team. They began putting this list together just a week or two ago.

(23 Sep '10, 13:02) Graeme Perrow

@Graeme: Nice that you keep the list current!

(08 Nov '10, 16:05) Volker Barth
Your answer
toggle preview

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

Question tags:

×238
×78

question asked: 22 Sep '10, 08:40

question was seen: 6,356 times

last updated: 08 Nov '10, 15:17