Ohio North SQL Server User Group

Choose a meeting below to view its details

Meeting Archive




ONSSUG Meeting March 2018 - Erin Stellato - Migrating to In-Memory OLTP

  • In-Person @ 6050 Oak Tree Blvd. Independence, Ohio, United States (map)
  • 17:00 - 19:30 (UTC-05:00) Eastern Time (US & Canada)
  • Language: English

Please RSVP for the meeting!
For this session, we we watch a video from 2017 PASS Summit on Realtime Analytics: OLAP & OLTP in the mix! presented by Stijn Wynants. Then, Luis will regale us with news from PASS on upcoming events.

Please use this link to see the video and slide deck.

Also see the attached zip file containing the corresponding materials.

Featured Presentation:

Migrating to In-Memory OLTP

Erin Stellato, Principal Consultant SQLskills

When In-Memory OLTP was originally introduced it seemed to be the answer to all our problems. No locking! No latching! 100x performance gains! But just as there is no spoon, there is no silver bullet with SQL Server, and In-Memory is not a quick-fix for every scenario. But it *could* be a solution for your environment. How do you know? That's what we'll talk about in this session. We'll discuss the basics of In-Memory and then cover topics such as candidate workloads, figuring out what to migrate, and testing methods that you can use to determine if it really does provide a performance boost. Along the way we'll clear up any misconceptions you have about In-Memory OLTP, and you'll walk out of the session knowing whether this is something you should pursue, or put on the back burner until the right opportunity comes along.

About Erin:
Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 17 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery. Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.

Supplementary Materials

The following event attachments are available to you:

Back to Top