The web application is blocked while processing another web application while sharing the same session

Question

Two WebApplications are deployed in IIS, namely / HRMS, / TravelDesk. Both WebApps use session through AspState, configuration information

<sessionState allowCustomSqlDatabase="true" mode="SQLServer" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="Application Name=Portal;data source=localhost;Initial Catalog=ASPState;User ID=sa;Password=dev2005" cookieless="false" compressionEnabled="true" timeout="720"/> 

The user is registered in the application / HRMS, from which he goes to the TravelDesk application in a new window, the session becomes common for two web applications.

In TravelDesk, a user tries to load a bunch of information, and it takes more time to process the request on the server. At the same time, I am trying to access the / HRMS application, but it does not respond until TravelDesk completes?

will a lock session occur in SQLServer? Please help me solve this problem.

Answer 1

  the session is getting shared across the two web apps 

If the session is split between two web applications, then yes, this is the reason. The session blocks the response.

To avoid this, in the huge download information, disconnect the session (only on the handler or on the page that does the loading).

Relative: Completing an entire ASP.Net session