Post reply

Enable In OLTP memory Engine in SQL 2014

  • April 11, 2014 at 8:22 am

    #292266

    Hi Experts,

    I have just installed enterprise edition SQL 2014 on our new server, however the memory optimization (in OLTP memory) is disabled.

    Please can any one help me to enable it

    Regards,

    Ashif

  • April 11, 2014 at 8:48 am

    #1705341

    I found that it is due to 'Light weight pooling' is enabled, in OLTP memory engine it is asking me to disable.

    Please let me know what will be the consequence if I disable it.

    Regards,

    Ashif

  • April 11, 2014 at 9:55 am

    #1705391

    Why are you even running fibre mode? It's not a generally recommended setting, very advanced, It disabled or breaks so many other things.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 12, 2014 at 6:32 am

    #1705522

    After you make the change that Gail suggests, here's a very large percentage of everything you need to know about In-Memory OLTP. Make sure you read through all the recommendations on loads that benefit from this new functionality. It's not going to work well for everyone or every application. You need to be selective.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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