SQL Server interview questions: - How will you explain stateless and stateful load balancing?
Following way you can answer this SQL Server interview questions.
Stateless load balancer
Stateless load balancer uses the hashing algorithm. It takes packet from the client and selects fields from the packet to be hashed. For instance from each client it can take IP address and port number and hash them in to an integer between 1 to number of servers. You can see from the figure we have four servers. So the load balancer takes the IP address and port and hashes them with a number between 1 to 4. Depending on the number the client is directed to the server. For instance client A is directed to server 2, client b to server 1 and so on. Once the client is connected to a server it is always redirected to the same server.
Figure: - Stateless load balancing
Advantage of stateless load balancing is that itís simple. The biggest disadvantage is that it treats all clients equally and connects one client to one server always. That is if client A is connects to server 2 it will always connect to server 2. This is irrespective of how many times client A sends request. So if client A sends 100 request and client B sends 10 requests even then client will be sent to server 2 for all the 100 request and client B to server 1 for all requests.
Stateful load balancer
In stateful balancing the load balancer looks at each session and assigns it to the appropriate server based on load. In order that the load balancer can track each session it needs to know when the session starts and when it ends.
Figure: - Stateful load balancing
You can see from the figure for every session the load balancer redirects the request to different servers.
See the following video on Data Access layer used in Enterprise Application Block as follows: -
Click for more SQL Server interview questions
Visit for more authorís blog on SQL Server interview questions