APPLICATION LAYER
SOCKET INTERFACE PROGRAMMING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Theoretically, how many clients can a server manage before being overloaded when using single-thread connections?
|
|
100
|
|
|
1000
|
|
|
1, 000, 000
|
|
|
∞
|
Explanation:
Detailed explanation-1: -A single listening port can accept more than one connection simultaneously. There is a ‘64K’ limit that is often cited, but that is per client per server port, and needs clarifying.
Detailed explanation-2: -Hi, By default, SQL Server allows a maximum of 32767 concurrent connections which is the maximum number of users that can simultaneously log in to the SQL server instance.
Detailed explanation-3: -Then theoretical limit a server can support on a single port is 248 which is about 1 quadrillion because: The server distinguishes the connections from clients’ source IPs and the source ports. [number of source IP addresses]x[num of source ports] 32 bits for the address and 16 bits for the port.
There is 1 question to complete.