BT

Your opinion matters! Please fill in the InfoQ Survey!

Migration Analyzer for SQL Server’s In-Memory OLTP

| by Jonathan Allen Follow 247 Followers on Sep 30, 2013. Estimated reading time: less than one minute |

A note to our readers: As per your request we have developed a set of features that allow you to reduce the noise, while not losing sight of anything that is important. Get email and web notifications by choosing the topics you are interested in.

One of the biggest challenges when researching a new technology is determining where to start. A typical SQL Server installation could easily have hundreds of tables. Examining each one by hand to determine which would benefit from conversion, is a daunting challenge. This is where the AMR Tool comes into play.

Short for Analyze, Migrate, Report, the AMR tool consists of three components. The first component is the Management Data Warehouse. This is a relational database, hosted inside SQL Server, which is used for logging performance metadata for another database instance. Generally speaking this is installed on a separate machine, often just a test server or laptop.

A set of lightweight data collectors are attached to the database being examined. These collectors send dump the raw information into the aforementioned Management Data Warehouse.

Finally there are the reports themselves. These examine tables and stored procedures for two criteria: easy of migration and expected gains. Here is an example from the AMR announcement,

This concludes our coverage of SQL Server 2014’s In-Memory OLTP.

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT