There appears to be a new way to support Session State in SQL 2014 called 'In-Memory'. Below is one take on it. https://blogs.msdn.microsoft.com/ke...net-session-state-using-sql-server-in-memory/ NuGet package: Install-Package Microsoft.Web.SessionState.SqlInMemory The script points to a file object for creation: CREATE DATABASE [MyDB] ON PRIMARY ( NAME = MyDB, FILENAME = 'D:\SQL\data\MyDB_data.mdf' ), FILEGROUP MyDB_xtp_fg CONTAINS MEMORY_OPTIMIZED_DATA ( NAME = MyDB_xtp, FILENAME = 'D:\SQL\data\MyDB_xtp' ) GO My question: Is this supported on Everleap? Thank you
On the shared SQL servers I would expect the answer will be 'no' (but I'll check). We could probably enable it if you're using Managed SQL though.
Alan Hord, it turns out that's an Enterprise Edition feature, so it wouldn't be available in the web edition that we run. Enterprise is available with Managed SQL, but it's considerably more expensive than the web or standard editions (due to Microsoft licensing fees which make quite a steep jump between Standard and Enterprise).
