15/01/2014 8:40:02 AM
SQL Server 2014 In-Memory OLTP (aka "Hekaton") is one of the most significant performance optimisations ever made to SQL Server's core OLTP database engine by Microsoft. In-Memory OLTP is a complete re-design of the database engine, promising speed improvements many times over the existing engine by elimination of storage i/o during query processing, removal of existing locking mechanisms & use of native code compilation (to .dlls rather than interpreted query plans).
Microsoft has integrated In-Memory OLTP directly into the core database engine, allowing tables & stored procedures to be simply converted as In-Memory OLTP objects and used normally. Limits apply to supported column types & TSQL language features in the initial SQL 2014 release however, so some planning is required prior to implementing In-Memory OLTP
In this presentation, Greg Linwood walks us through In-Memory OLTP demonstrating its core features and discussing how you can harness its power.
About Greg Linwood
Greg Linwood is a SQL Server performance tuning specialist and Managing Director of MyDBA - an international SQL Server support & consulting business. Greg has developer & DBA experience with SQL Server since 1993 and was the first Australian to receive Microsoft's SQL Server "Most Valuable Professional" (MVP) award in 2003. Greg is a founder of the Australian SQL Server User Group, founding the Melbourne SQL Server User Group in 2003.
Venue: Microsoft Level 5, Building 4, Freshwater Place, Southbank , Melbourne, VIC |
Duration 5:30PM pizzas & drinks for 6:00 start, approx 7:45pm finish |
On: Tuesday, 21 January 2014