ASP.NET Session State using SQL Server In-Memory

Discussion in 'Databases' started by Alan Hord, Jun 17, 2016.

  1. 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 :)
     
  2. mjp

    mjp

    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.
     
  3. mjp

    mjp

    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).
     

Share This Page