locked
in memory tables in standard edition (not p1,p2 premium) RRS feed

  • Question

  • Is it possible to have in memory tables in standard edition (not p1,p2 premium) in sql azure?

    MCTS Sharepoint 2010, MCAD dotnet, MCPDEA, SharePoint Lead

    Sunday, February 12, 2017 2:08 PM

Answers

  • In-Memory OLTP requires a Premium tier.  See https://docs.microsoft.com/en-us/azure/sql-database/sql-database-in-memory.


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com

    Sunday, February 12, 2017 2:21 PM

All replies

  • In-Memory OLTP requires a Premium tier.  See https://docs.microsoft.com/en-us/azure/sql-database/sql-database-in-memory.


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com

    Sunday, February 12, 2017 2:21 PM
  • thanks!

    Now question is we have 500k items in each of multiple tables in sql 2012 with 40+ columns.(sometimes 1 million)

    Now if we convert these tables to in memory and migrate to p1 premium azure sql(5k$ per year) will it significantlyreduce read oprations around these tables?

    For example if stored proc or select * from 1million table takes 1 minute in sql 2012 will it be in 10 seconds in azure p1 with in memory enabled for these tables? if there is no significant benefit for above scenario we do not need it for above scenario but if answer is yes then we are ready to pay premium!!


    MCTS Sharepoint 2010, MCAD dotnet, MCPDEA, SharePoint Lead



    Monday, February 13, 2017 9:19 PM
  • >Now if we convert these tables to in memory and migrate to p1 premium azure sql(5k$ per year) will it significantlyreduce read oprations around these tables?

    Just test it.  You can simply restore a copy of your database to test with, and drop it when you're done.

    Also consider Columnstore instead of memory-optimized tables.  Columnstore is best for large reads, while Memory-Optimized tables are best for fast, concurrent writes.

    David


    Microsoft Technology Center - Dallas

    My Blog



    Monday, February 13, 2017 11:44 PM
  • For example if stored proc or select * from 1million table takes 1 minute in sql 2012 will it be in 10 seconds in azure p1 with in memory enabled for these tables?

    Does your actual query selects all columns with no WHERE clause? As David suggested, columnstore may be a better option for full scans, especially if you limit the number of columns.


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com

    Tuesday, February 14, 2017 1:26 AM