Add support for ASP.NET Sessions in SQL Azure (without a custom provider)
Although we can get ASP.NET Roles and Profiles working with SQL Azure, we still can't get ASP.NET Sessions working Please add support for ASP.NET Sessions in SQL Azure without a need for me to write a custom provider or have to create a worker role to clean up expired sessions.
Ed Johnson commented
problem with caching session state provider is that it is SLOWER than using sql azure for session state management - plus you have to use the hotfix if you are using reportviewer which slows down deployment exponentially - really sql azure session IS FASTER than shared cache hands down
Pickup Director commented
Just use the Azure Caching session state provider (currently in Preview).
Scott Simpson commented
I would have thought Microsoft would implement a fast object caching method for managing sessions as part of Azure rather than doing blob or sql storage. We use a product called Scale Out State Server. Alachisoft makes another. These products are great for server farm scaling. This type of solution could be built in seamlessly as part of Azure and support asp.net distributed sessions without having a sql azure account.
Dave Bacher commented
What would happen if you ran the TCP session state provider in a worker role?
Emmanuel Huna commented
Thanks Mike, I added it on as well :
This needs to be implemented by both the ASP.NET and SQL Azure teams at Microsoft - that's the reason I posted it in both (and also the reason I think this will be harder to coordinate and implement)
Thanks for suggesting this. I just added a forum specifically for SQL Azure to make sure there's a place to make sure those ideas can be captured as well, check it out. http://mygreatsqlazureidea.com/