I am moving a site from one server to a server farm consisting of three web servers behind a load balancer. It seems easy enough to handle session management - just make the sessions sticky on the Load Balancer (we appreciated SQL-based session management, but decided to continue using InProc session management to increase efficiency).
However, we also use a significant configuration object that we store in the application space (for example, Application [ObjName]). Since the configuration object is loaded from memory, we have no problem until someone changes the configuration. At this point, the application on the hosting server will have changes, and there will be changes in the database. However, the other two servers will not be affected. We discussed the βonce per minuteβ rule of polling (for example, in new sessions), instead storing information in the session (not very efficiently), etc. Everyone has serious flaws. I wonder what other people are doing. Is it possible to save application space on SQL Server but inproc session space? Any help or understanding on how to handle this will be appreciated!
source share