Name: In-Memory OLTP: Internals and System Design Considerations
Start: 2017-07-03T18:30:00+01:00
End: 2017-07-03T21:30:00+01:00
Location: Microsoft Ireland (Sandyford Luas Stop)

Synopsis:
In-Memory OLTP is one of the key SQL Server technologies, which can significantly improve performance of OLTP systems. In-Memory OLTP in SQL Server 2016 comes with many enhancements that reduce technology limitations and improve its usability. In many cases, you can even migrate the data into memory transparently to the code. Unfortunately, this simplicity may lead to suboptimal solutions due to the differences in technology behavior with the Classic Storage Engine.

This session provides the overview of In-Memory OLTP architecture and its internal implementation. It explains the key differences between the In-Memory OLTP and Storage Engines and gives the set of guidelines that may help during in-memory migration. Finally, the session demonstrates how to benefit from the technology in the systems with mixed (OLTP + DW) workloads when full in-memory migration is impossible or impractical. .

Bio:

Dmitri is a Microsoft SQL Server MVP and Microsoft Certified Master, author of "Pro SQL Server Internals" and "Expert SQL Server In-Memory OLTP" (http://amazon.com/author/dmitri-korotkevitch) with over 15 years of experience working with SQL Server as an Application and Database Developer, DBA, and Database Architect. Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.

https://secure.meetupstatic.com/photos/event/2/0/7/f/600_459728319.jpeg

Bob Duffy

SQL Ireland User Group

Azure Data Tech Groups

Technology

SQL Server

Advanced SQL Server

Microsoft Azure

Database Professionals

Data Management

Business Intelligence

Big Data

Database Development

Data Visualization

Predictive Analytics

Data Mining

In-Memory OLTP: Internals and System Design Considerations

Microsoft Ireland (Sandyford Luas Stop)

Share

SQL Ireland User Group

In-Memory OLTP: Internals and System Design Considerations

SQL Ireland User Group

Details

Members are also interested in