Alan Featherston(TradeMe) on In-Memory OLTP
Details
Hi All,
This month we are lucky enough to have Alan Featherston from TradeMe taking us through his findings from the research he's been doing into In-Memory OLTP. This is a technology that Microsoft has had at the front of their promotional queues for a while now and can result in some huge performance gains in the right circumstances.
Alan is a Database Administrator originally from Buenos Aires and currently working at Trade Me. He works with a great team of DBAs making sure one of NZ's most active websites stays up and fast. Alan has been a DBA for almost 9 years and before migrating to NZ he worked for the government and gambling industry, where his focus was and also around high performance/low latency data systems.
As always come to 111 Bridge Street, use the side door not the main entrance, and be there for Pizza and Drinks at 5:30 with the presentation set to start at 6pm.
See you there!
Summary
SQL Server In-Memory OLTP can give you the opportunity to radically speed your applications. The presentation offers a quick intro to how it works, what's new and some guidelines about good use case scenarios.
Abstract
SQL Server Hekaton, aka In-Memory OLTP, was released in SQL Server 2014, two years later SQL Server 2016 introduces some changes that might finally help Microsoft reach wider adoption. Every DBA needs to understands how this technology works (not only Microsofts take but the state of the art of in-memory RDBMS) and what to expect when a new project might benefit from it.
Goals:
-A basic under the hood understanding of In-Memory OLTP
-How to monitor and possibly troubleshoot potential issues
-Understand usage patters
-What's new in 2016