locked
'MEMORY_OPTIMIZED tables' is not supported in this service tier of the database. See Books Online for more details on feature support in different service tiers of Windows Azure SQL Database. RRS feed

  • Question

  • getting below error in Premium p1 tier database in azure sql-

    'MEMORY_OPTIMIZED tables' is not supported in this service tier of the database. See Books Online for more details on feature support in different service tiers of Windows Azure SQL Database.

    I created new database yesterday only.


    MCTS Sharepoint 2010, MCAD dotnet, MCPDEA, SharePoint Lead


    Tuesday, December 20, 2016 9:54 PM

Answers

  • https://docs.microsoft.com/en-us/azure/sql-database/sql-database-in-memory

    "Downgrade to Basic/Standard. In-Memory OLTP is not supported in databases in the Standard or Basic tier. In addition, it is not possible to move a database that has any In-Memory OLTP objects to the Standard or Basic tier."

    The behavior you're seeing seems to be expected.
    • Marked as answer by pituachMVP Friday, May 10, 2019 6:50 AM
    Wednesday, December 21, 2016 1:10 AM
  • In-Memory OLTP is supported in premium elastic pools since early November.

    Thanks,

    Jos

    • Marked as answer by pituachMVP Friday, May 10, 2019 6:51 AM
    Tuesday, January 3, 2017 4:33 PM

All replies