{"id":4975,"date":"2015-06-17T06:28:30","date_gmt":"2015-06-17T04:28:30","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/"},"modified":"2015-06-17T06:28:30","modified_gmt":"2015-06-17T04:28:30","slug":"sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/","title":{"rendered":"SQL Server 2014: Analysis, Migrate and Report (AMR) &#8211; a powerful In-Memory migration tool"},"content":{"rendered":"<p style=\"line-height: normal;\">An important new functionality of Microsoft SQL Server 2014 is the In-Memory OLTP engine, which enable you to load Tables and also Stored Procedures In-Memory for a very fast response time.<br \/> The goal is not to load all the database In-Memory but just Tables with critical performances and Stored Procedures with complex logical calculations.<\/p>\n<p style=\"line-height: normal;\">To identify which Tables or Stored Procedures will give you the best performance gain after migration; Microsoft SQL Server 2014 has introduced a new tool: Analysis, Migrate and Report (AMR).<\/p>\n<p style=\"line-height: normal;\">This tool will collect statistics about Tables and Stored Procedures in order to analyze the current workload. It will give you advice on the migration benefits of the different Tables or Stored Procedures. It will also give you an overview of the time\/work needed to push Tables or Stored Procedures In-Memory.<\/p>\n<p style=\"line-height: normal;\">In the following article I will show you how to setup and use this Tool.<\/p>\n<h2>Configuration of the Management Data Warehouse<\/h2>\n<p style=\"line-height: normal;\">The AMR Tool is built into SQL Server Management Studio.<br \/> It consists of:<\/p>\n<ul>\n<li>Reports which come from a Management Data Warehouse and give recommendations about tables and Stored procedures which could be migrated to In-Memory OLTP<\/li>\n<li>Memory Optimization Advisor which will help you during the migration process of a disk table to a Memory Optimized table<\/li>\n<li>Native Compilation Advisor which will help you migrated a Stored Procedure to a Natively Compiled Stored Procedure<\/li>\n<\/ul>\n<p style=\"line-height: normal;\">AMR Tool leverages the Management Data Warehouse and the Data Collector, with his new Transaction Performance Collection Sets, for gathering information about workloads.<\/p>\n<p style=\"line-height: normal;\">AMR will analyze the collected data and provide recommendations via reports.<br \/> First, we have to configure the Management Data Warehouse.<\/p>\n<p>To start the configuration, open Management Studio, go to Object Explorer, then Management folder, and right-click on Data Collection. Then select Tasks and click on Configure Management Data Warehouse as shown below:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"AMR_picture1.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture1.png\"><img decoding=\"async\" title=\"AMR_picture1.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture1.png\" alt=\"AMR_picture1.png\" \/><\/a><\/p>\n<p style=\"line-height: normal;\">On the Configure Management Data Warehouse Storage screen, enter the server name and the database name where you Management Data Warehouse will be host. AMR tool will collect, via its collection sets, data from three Dynamic Management Views every fifteen minutes and will save those data in the MDW database. Uploading data will have minimal performance impact.<\/p>\n<p style=\"line-height: normal;\">If you already have a database, enter her name. If not, click the New button to create a new one.<br \/> On the Map logins and Users page, if needed, you can map a user to administer, read, or write the Data Management Warehouse database.<br \/> Verify the Management Data Warehouse configuration and proceed to the configuration.<br \/> When the configuration of the Management Data Warehouse has been successfully finalized, you should see the following screen:<\/p>\n<p style=\"line-height: normal;\">\u00a0<a class=\"easyblog-thumb-preview\" title=\"AMR_picture2.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture2.png\"><img decoding=\"async\" title=\"AMR_picture2.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture2.png\" alt=\"AMR_picture2.png\" \/><\/a><\/p>\n<p style=\"line-height: normal;\">The Management Data Warehouse setup is finished.<\/p>\n<h2>Configuration of the Data collection<\/h2>\n<p style=\"line-height: normal;\">Take care, SQL Server agent has to be started on the instance that will collect the data.<br \/> To collect data, we will enable the new Transaction Performance Collection set which is composed of two new collection sets:<\/p>\n<ul>\n<li>Stored Procedure Usage Analysis: used to capture statistics about Stored Procedures which could be migrate to Natively Compiled Stored Procedures<\/li>\n<li>Table Usage Analysis: takes information about disk based tables for a future migration to Memory Optimized tables.<\/li>\n<\/ul>\n<p>\u00a0<span style=\"font-size: 11pt; line-height: 115%; font-family: 'Calibri',sans-serif;\">In order to configure the Data Collection, go to Object Explorer, then Management folder, right-click on Data Collection, select Tasks, and click on Configure Data Collection, as shown below:<\/span><\/p>\n<p><span style=\"font-size: 11pt; line-height: 115%; font-family: 'Calibri',sans-serif;\"><a class=\"easyblog-thumb-preview\" title=\"AMR_picture3.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture3.png\"><img decoding=\"async\" title=\"AMR_picture3.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture3.png\" alt=\"AMR_picture3.png\" \/><\/a><\/span><\/p>\n<p style=\"line-height: normal;\">After having skipped the Welcome page, you have to select a server and a database name that will host the Management Data Warehouse.<\/p>\n<p style=\"line-height: normal;\">Now, you need to select the data collector sets. In the wizard, check \u201cTransaction Performance Collection Set\u201d in the list of collection sets. This will collect statistics for transaction performance issues.<\/p>\n<p> If the Management Data Warehouse is located on a different SQL Server instance from the data collector and SQL Server agent is not running under a domain account which has dc_admin permissions on the remote instance you have to use a SQL Server Agent proxy.<\/p>\n<p><span style=\"font-size: 11pt; line-height: 115%; font-family: 'Calibri',sans-serif;\"><a class=\"easyblog-thumb-preview\" title=\"AMR_picture4.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture4.png\"><img decoding=\"async\" title=\"AMR_picture4.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture4.png\" alt=\"AMR_picture4.png\" \/><\/a><\/span><\/p>\n<p style=\"line-height: normal;\">After having performed the Data Collection configuration with success, you will have an enabled Data Collection which will collect information about all user databases.<\/p>\n<p>Via SQL Server Agent Folder Jobs, you are now able to see new collection jobs used to collect data from your workloads with names like collection_set_N_collection and jobs used to populate our new Management Data Warehouse database with names like collection_set_N_upload.<\/p>\n<p>It is also good to know that upload jobs will be run every thirty minutes for Stored Procedure Usage Analysis (job: collection_set_5_upload) and every fifteen minutes for Table Usage Analysis (job: collection_set_6_upload). So if you want to speed your upload, you can execute these jobs manually. <br \/>\u00a0<\/p>\n<h1>Reports<\/h1>\n<p style=\"line-height: normal;\">To access recommendations based on collected information about all user databases on the workload server, you have to right-click on your Management Data Warehouse database, select Reports, then Management Data Warehouse, and finally Transaction Performance Analysis.<\/p>\n<p style=\"line-height: normal;\">In the Transaction Performance Analysis Overview report, you can choose among three reports, depending on what you want or need:<\/p>\n<ul>\n<li>Usage analysis for tables<\/li>\n<li>Contention analysis for tables<\/li>\n<li><span style=\"font-size: 11pt; line-height: 115%; font-family: 'Calibri',sans-serif;\"><span style=\"font-size: 11pt; line-height: 115%; font-family: 'Calibri',sans-serif;\">Usage analysis for Stored procedures<\/span><\/span><\/li>\n<\/ul>\n<p><a class=\"easyblog-thumb-preview\" title=\"AMR_picture5.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture5.png\"><img decoding=\"async\" title=\"AMR_picture5.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture5.png\" alt=\"AMR_picture5.png\" \/><\/a><\/p>\n<h2>Usage analysis for tables<\/h2>\n<p style=\"line-height: normal;\">This report, based on table&#8217;s usage, shows you best candidate tables that could be pushed In-Memory. <br \/> On the left side of the report you have the possibility to select the database and the number of tables you would like to see.<br \/> The central part is a chart with two axis:<\/p>\n<ul>\n<li>Horizontal axis represents significant to minimal works needed to migrate a table to In-Memory OLTP<\/li>\n<li>Vertical axis represents increasing gains you will benefit after having moved the table to In-Memory OLTP<\/li>\n<\/ul>\n<p style=\"line-height: normal;\">The best part of this graph is the top right corner, which shows tables that could be migrated easily In-Memory, but will give you the best performance gain.<\/p>\n<p style=\"line-height: normal;\"><a class=\"easyblog-thumb-preview\" title=\"AMR_picture6.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture6.png\"><img decoding=\"async\" title=\"AMR_picture6.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture6.png\" alt=\"AMR_picture6.png\" \/><\/a><\/p>\n<p style=\"line-height: normal;\">When you click a table point on the graph, you will access a more detailed statistics report.<\/p>\n<p style=\"line-height: normal;\">This report shows access characteristics (lookup statistics, range scan statistics, etc.) and also contention statistics (latches statistics, lock statistics, etc.) of the concerning table and for the monitoring time period of your instance\u2019s workload with the Transaction Performance Collection Set.<\/p>\n<p style=\"line-height: normal;\"><a class=\"easyblog-thumb-preview\" title=\"AMR_picture7.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture7.png\"><img decoding=\"async\" title=\"AMR_picture7.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture7.png\" alt=\"AMR_picture7.png\" \/><\/a><\/p>\n<h2>Contention analysis for table<\/h2>\n<p style=\"line-height: normal;\">This report is based on table&#8217;s contention instead of usage. It shows you best candidate tables that could be migrated In-Memory. <br \/> As before, on the left side of the report you have the possibility to select the database and the number of tables you would like to see.<br \/> The central part is a chart with two axis:<\/p>\n<ul>\n<li>Horizontal axis represents significant to minimal works needed to migrate a table to In-Memory OLTP<\/li>\n<li>Vertical axis represents increasing gains you will benefit after having moved the table to In-Memory OLTP<\/li>\n<\/ul>\n<p style=\"line-height: normal;\">The best part of this graph is the top right corner, showing tables that can be easily migrated In-Memory, but will give you best performance gain.<\/p>\n<p style=\"line-height: normal;\"><a class=\"easyblog-thumb-preview\" title=\"AMR_picture8.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture8.png\"><img decoding=\"async\" title=\"AMR_picture8.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture8.png\" alt=\"AMR_picture8.png\" \/><\/a><\/p>\n<p style=\"line-height: normal;\">As for the usage analysis report, you can also click a table name on the graph to see the statistics details of the table.<\/p>\n<h2>Usage analysis for Stored Procedures<\/h2>\n<p style=\"line-height: normal;\">This report contains the top candidate stored procedures for an In-Memory OLTP migration with regards to their usage. This report is based on the Total CPU Time.<\/p>\n<p style=\"line-height: normal;\">You also have the possibility to select the database and the number of stored procedure you would like to see.<\/p>\n<p style=\"line-height: normal;\"><a class=\"easyblog-thumb-preview\" title=\"AMR_picture9.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture9.png\"><img decoding=\"async\" title=\"AMR_picture9.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture9.png\" alt=\"AMR_picture9.png\" \/><\/a><\/p>\n<p style=\"line-height: normal;\">If you want to see the usage statistics for a specific stored procedure, you can click on the blue bar. You will then have a more detailed report.<\/p>\n<p style=\"line-height: normal;\"><a class=\"easyblog-thumb-preview\" title=\"AMR_picture10.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture10.png\"><img decoding=\"async\" title=\"AMR_picture10.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture10.png\" alt=\"AMR_picture10.png\" \/><\/a><\/p>\n<p>Now, you know which Tables and Stored Procedures will give you best performance gain after migration to In-Memory OLTP.<br \/> AMR provide us two Advisors which will help you to manage the transformation of your disk tables to Memory Optimized Tables as well as your Stored Procedures to Natively Compiled Stored Procedures. To know more about those advisors, please have a look to <a href=\"\/sql-server-2014-ctp2-tables-and-stored-procedures-advisor\">my blog<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>An important new functionality of Microsoft SQL Server 2014 is the In-Memory OLTP engine, which enable you to load Tables and also Stored Procedures In-Memory for a very fast response time. The goal is not to load all the database In-Memory but just Tables with critical performances and Stored Procedures with complex logical calculations. To [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":4976,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[48],"tags":[],"type_dbi":[],"class_list":["post-4975","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology-survey"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2014: Analysis, Migrate and Report (AMR) - a powerful In-Memory migration tool - dbi Blog<\/title>\n<meta name=\"description\" content=\"An important new functionality of Microsoft SQL Server 2014 is the In-Memory OLTP engine, which enable you to load Tables and also Stored Procedures In-Memory for a very fast response time. The goal is not to load all the database In-Memory but just Tables with critical performances and Stored Procedures with complex logical calculations. To identify which Tables or Stored Procedures will give you the best performance gain after migration; Microsoft SQL Server 2014 has introduced a new tool: Analysis, Migrate and Report (AMR). This tool will collect statistics about Tables and Stored Procedures in order to analyze the current workload. It will give you advice on the migration benefits of the different Tables or Stored Procedures. It will also give you an overview of the time\/work needed to push Tables or Stored Procedures In-Memory.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2014: Analysis, Migrate and Report (AMR) - a powerful In-Memory migration tool\" \/>\n<meta property=\"og:description\" content=\"An important new functionality of Microsoft SQL Server 2014 is the In-Memory OLTP engine, which enable you to load Tables and also Stored Procedures In-Memory for a very fast response time. The goal is not to load all the database In-Memory but just Tables with critical performances and Stored Procedures with complex logical calculations. To identify which Tables or Stored Procedures will give you the best performance gain after migration; Microsoft SQL Server 2014 has introduced a new tool: Analysis, Migrate and Report (AMR). This tool will collect statistics about Tables and Stored Procedures in order to analyze the current workload. It will give you advice on the migration benefits of the different Tables or Stored Procedures. It will also give you an overview of the time\/work needed to push Tables or Stored Procedures In-Memory.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-06-17T04:28:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1237\" \/>\n\t<meta property=\"og:image:height\" content=\"514\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Savorgnano\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Savorgnano\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/\"},\"author\":{\"name\":\"St\u00e9phane Savorgnano\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"headline\":\"SQL Server 2014: Analysis, Migrate and Report (AMR) &#8211; a powerful In-Memory migration tool\",\"datePublished\":\"2015-06-17T04:28:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/\"},\"wordCount\":1311,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture1.png\",\"articleSection\":[\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/\",\"name\":\"SQL Server 2014: Analysis, Migrate and Report (AMR) - a powerful In-Memory migration tool - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture1.png\",\"datePublished\":\"2015-06-17T04:28:30+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"description\":\"An important new functionality of Microsoft SQL Server 2014 is the In-Memory OLTP engine, which enable you to load Tables and also Stored Procedures In-Memory for a very fast response time. The goal is not to load all the database In-Memory but just Tables with critical performances and Stored Procedures with complex logical calculations. To identify which Tables or Stored Procedures will give you the best performance gain after migration; Microsoft SQL Server 2014 has introduced a new tool: Analysis, Migrate and Report (AMR). This tool will collect statistics about Tables and Stored Procedures in order to analyze the current workload. It will give you advice on the migration benefits of the different Tables or Stored Procedures. It will also give you an overview of the time\/work needed to push Tables or Stored Procedures In-Memory.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture1.png\",\"width\":1237,\"height\":514},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2014: Analysis, Migrate and Report (AMR) &#8211; a powerful In-Memory migration tool\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\",\"name\":\"St\u00e9phane Savorgnano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Savorgnano\"},\"description\":\"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals &amp; Pharmaceuticals, etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2014: Analysis, Migrate and Report (AMR) - a powerful In-Memory migration tool - dbi Blog","description":"An important new functionality of Microsoft SQL Server 2014 is the In-Memory OLTP engine, which enable you to load Tables and also Stored Procedures In-Memory for a very fast response time. The goal is not to load all the database In-Memory but just Tables with critical performances and Stored Procedures with complex logical calculations. To identify which Tables or Stored Procedures will give you the best performance gain after migration; Microsoft SQL Server 2014 has introduced a new tool: Analysis, Migrate and Report (AMR). This tool will collect statistics about Tables and Stored Procedures in order to analyze the current workload. It will give you advice on the migration benefits of the different Tables or Stored Procedures. It will also give you an overview of the time\/work needed to push Tables or Stored Procedures In-Memory.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2014: Analysis, Migrate and Report (AMR) - a powerful In-Memory migration tool","og_description":"An important new functionality of Microsoft SQL Server 2014 is the In-Memory OLTP engine, which enable you to load Tables and also Stored Procedures In-Memory for a very fast response time. The goal is not to load all the database In-Memory but just Tables with critical performances and Stored Procedures with complex logical calculations. To identify which Tables or Stored Procedures will give you the best performance gain after migration; Microsoft SQL Server 2014 has introduced a new tool: Analysis, Migrate and Report (AMR). This tool will collect statistics about Tables and Stored Procedures in order to analyze the current workload. It will give you advice on the migration benefits of the different Tables or Stored Procedures. It will also give you an overview of the time\/work needed to push Tables or Stored Procedures In-Memory.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/","og_site_name":"dbi Blog","article_published_time":"2015-06-17T04:28:30+00:00","og_image":[{"width":1237,"height":514,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture1.png","type":"image\/png"}],"author":"St\u00e9phane Savorgnano","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Savorgnano","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/"},"author":{"name":"St\u00e9phane Savorgnano","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"headline":"SQL Server 2014: Analysis, Migrate and Report (AMR) &#8211; a powerful In-Memory migration tool","datePublished":"2015-06-17T04:28:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/"},"wordCount":1311,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture1.png","articleSection":["Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/","name":"SQL Server 2014: Analysis, Migrate and Report (AMR) - a powerful In-Memory migration tool - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture1.png","datePublished":"2015-06-17T04:28:30+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"description":"An important new functionality of Microsoft SQL Server 2014 is the In-Memory OLTP engine, which enable you to load Tables and also Stored Procedures In-Memory for a very fast response time. The goal is not to load all the database In-Memory but just Tables with critical performances and Stored Procedures with complex logical calculations. To identify which Tables or Stored Procedures will give you the best performance gain after migration; Microsoft SQL Server 2014 has introduced a new tool: Analysis, Migrate and Report (AMR). This tool will collect statistics about Tables and Stored Procedures in order to analyze the current workload. It will give you advice on the migration benefits of the different Tables or Stored Procedures. It will also give you an overview of the time\/work needed to push Tables or Stored Procedures In-Memory.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/AMR_picture1.png","width":1237,"height":514},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-analysis-migrate-and-report-amr-a-powerful-in-memory-migration-tool\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2014: Analysis, Migrate and Report (AMR) &#8211; a powerful In-Memory migration tool"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c","name":"St\u00e9phane Savorgnano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","caption":"St\u00e9phane Savorgnano"},"description":"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals &amp; Pharmaceuticals, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4975","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=4975"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4975\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4976"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4975"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4975"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4975"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4975"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}