Session Management in SQL Azure DB deleting sessions automatically RRS feed

  • Question

  • Implemented ASP.NET web role and implemented session handing using ASP.NET universal providers to store the session state in SQl Azure DB.

    The table named as Sessions got automatically created and sessions records were saved in SQL Azure DB table. Session timeout as 2 minutes. As per the guideline it is expected that, session records from this table should not get automatically deleted and we will have to call DeleteExpiredSession SP manually to clean up unused sessions.

    However, I observed that the session records are getting deleted automatically upon expiry from SQL Azure sessions table. This is surprising. Is this a new behaviour added to SQL Azure and ASP.NET universal provider?

    Please answer to only bold text above.


    Sunday, July 27, 2014 3:43 AM


All replies