Database Administration 1727.Transformational In Memory Performance

Published on January 20th, 2015 | by Warner Chaves

0

Video: Sql Server 2014 In-Memory OLTP Use Case: “The Landing Pad”

In this demo we’re going to show a performance comparison between Classic and In-Memory for the pattern known as the “landing pad” or “shock absorber”.

Basically, taking a large amount of data (3 million records on a 200MB CSV file in this case) and comparing the behavior and speed when inserting into a normal disk-based table and a new memory-optimized table.

This is a very useful pattern that you can apply immediately on your ETL process and get speed gains from In-Memory OLTP. See the video for the details!

Tags: , , , ,


About the Author

SQL Server Certified Master and MVP. DBA for MS technologies for over 10 years.



Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Back to Top ↑
  • Sign Up For Our Newsletter

    Stay up to date on the latest from SQL Server products and Features.

    Sign Up Now

    Sign up for mailing list and receive new posts directly to your inbox.

    We promise never to share or sell any of your personal information.

  • Recent Posts

  • Categories

  • Archives

  • Tags

  • Topics

  • Subscribe to our RSS Feed


    sqlturbo.com A SQL Server Web Blog
    Canada, Ontario, Ottawa.
    http://sqlturbo.com

    The Authors