Post reply

Memory Optimization advisor (Next button is greyed out)

  • September 25, 2017 at 8:03 am

    #340396

    Create a new table with 8 column's and some data (714rows) (NO Index and other things)

  • September 26, 2017 at 4:02 am

    #1960916

    Someone with anwsers??

  • September 26, 2017 at 6:44 am

    #1960938

    What edition / version of SQL Server is the target?

    If it's SQL 2014 or SQL 2016 RTM Standard Edition, you won't be able to continue, as those don't support memory optimised tables.

    (I've just replicated your problem against a SQL2014 Standard Edition server...)

    See https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/requirements-for-using-memory-optimized-tables for more information

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • September 29, 2017 at 4:44 am

    #1961569

    ThomasRushton - Tuesday, September 26, 2017 6:44 AM

    What edition / version of SQL Server is the target?

    If it's SQL 2014 or SQL 2016 RTM Standard Edition, you won't be able to continue, as those don't support memory optimised tables.

    (I've just replicated your problem against a SQL2014 Standard Edition server...)

    See https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/requirements-for-using-memory-optimized-tables for more information

    Microsoft SQL Server Business Intelligence (64-bit)
    SQL Server 2014 database

  • September 29, 2017 at 4:54 am

    #1961570

    GG_BI_GG - Friday, September 29, 2017 4:44 AM

    Microsoft SQL Server Business Intelligence (64-bit)

    SQL Server 2014 database

    As stated in that page that Thomas linked to above:

    For SQL Server 2014 and SQL Server 2016 RTM (pre-SP1) you need Enterprise, Developer, or Evaluation edition.

    Business Intelligence  Edition is not Enterprise Edition and, thus, does not have access to use Memory-Optimized Tables. You will need to upgrade to Enterprise is you want to make use of the functionality.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply