ASA Database Administration Guide
Running the Database Server
Introduction
Although you can start a personal server in the simple way described above, there are many other aspects to running a database server in a production environment. For example,
You can choose from many options to specify such features as how much memory to use as cache, how many CPUs to use (on multi-processor machines), and the network protocols to use (network server only). The options are one of the major ways of tuning Adaptive Server Anywhere behavior and performance.
You can run the server as a Windows service. This allows it to continue running even when you log off the machine.
You can start the personal server from an application and shut it down when the application has finished with it. This is typical when using the database server an embedded database.
The remainder of this chapter describes these options in more detail.