T-SQL Tuesday #117 Invitation – When Have You Used MOT Tables?

When Memory-Optimized Tables (MOT) were announced for SQL Server, there was a lot of excitement about the technology. After this was released on SQL Server 2014, feelings waned with a lot of restrictions and limitations for using the technology. I remember a panel at a conference years ago where most of the MVPs and experts recommended against using the technology for most users.

Today there have been improvements (2017, 2016) in the MOT features, restrictions have been removed, and all editions can use MOT tables. That’s not to say that this is suitable for every table or situation where a DBA or developer suspects performance issues.

This month I want to ask you about when you’ve made that decision. This can be to use MOT tables or NOT to use MOT tables. This could be a simple thought, a POC, or actual testing of the feature.

Some ideas for you to write about:

  • Performance analysis of MOT tables that affected a decision
  • Reading the limitations and knowing this would prevent their use
  • A scenario where MOT tables improved performance
  • A successful implementation of MOT tables and what needed to change in your app
  • A failed attempt at trying MOT tables

There might be other things that are related to MOT technology, but let us know this month what you think of the technology and how it has (or has not) impacted your application.

The Rules

Here are the rules as set out for the T-SQL Tuesday blog party.

  1. Your post should be published on Tuesday, Aug 13, 2019 between midnight UTC and 11:59:59 UTC.
  2. Include the T-SQL Tuesday logo in your post.
  3. Link back to this invitation.
  4. Include a comment on the invitation post or a trackback link.
  5. Enjoy the chance to be creative and share some knowledge.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.

7 Responses to T-SQL Tuesday #117 Invitation – When Have You Used MOT Tables?

  1. Pingback: T-SQL Tuesday #116 – When Have You Used MOT Tables? – T-SQL Tuesday

  2. Pingback: A quick tuning win with Memory-Optimized Tables - LobsterPot Blogs

  3. Pingback: A Memory-Optimized Roundup – T-SQL Tuesday #117 | Voice of the DBA

Leave a Reply to Rob Farley Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.