Post reply

moving some of the 2014 tables and SP

  • June 27, 2014 at 12:28 am

    #290518

    Hi,

    We have migrated our prd db environment to SQL 2014,we are planning to move some of the tables and SP's to In-memory OLTP to improve performance to make use of Hekaton.

    Please do let me know some of the links or references which covers all the details of how we can move and DO's and DON't s

  • June 27, 2014 at 4:30 am

    #1725373

    Microsoft and the Books Online are our bestest friends in the world.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • June 27, 2014 at 4:32 am

    #1725375

    DO: Test first. Hekaton is not an automatic silver bullet for performance problems. You may get no gain, you may get a reduction in performance. If you don't have good DBAs who will keep an eye on things, you could end up with serious problems.

    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

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

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