June 27, 2014 at 12:28 am
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
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 27, 2014 at 4:32 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply