number of remote sites

Summary information

Default value

10

Range of values

0–32767

Status

Static

Display level

Intermediate

Required role

System administrator

Configuration groups

Memory Use, Network Communication

number of remote sites determines the maximum number of remote sites that can simultaneously access Adaptive Server. Each Adaptive Server-to-XP Server connection uses one remote site connection.

Internally, number of remote sites determines the number of site handlers that can be active at any one time; all server accesses from a single site are managed with a single site handler. For example, if you set number of remote sites to 5, and each site initiates three remote procedure calls, sp_who shows 5 site handler processes for the 15 processes. See Chapter 7, “Managing Remote Servers.”