1. Back To Blog

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.

 

sql

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.

 

sql

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

 

Regards,

 

Visit for more authorís blog on SQL Server interview questions

Shiv Prasad Koirala

Visit us @ www.questpond.com or call us at 022-66752917... read more

We are on Social