This can produce bottlenecks in a multi-user environment. A product designed to use a multi-process architecture creates new processes to handle each new request. Only one process will ever run on the server regardless of how many clients are connected. Sybase has indicated, however, that future implementations may be architected differently in order to take better advantage of alternate platforms and their inherent threading capabilities. SQL Server manages data and executes queries against the data that it administers.
Clients access the server, over the network, to request data.
Sybase provides Open Server and Open Client to enable this type of processing. These are two collections of libraries containing APIs that enable the client and the server to communicate. Open Client is required to enable client applications to send requests with SQL Server. Some SQL Server users still refer to Open Client by its older name, DB-Library. Open Server, on the other hand, is not required.