{"id":17785,"date":"2016-11-22T09:00:51","date_gmt":"2016-11-22T17:00:51","guid":{"rendered":""},"modified":"2024-07-02T10:15:31","modified_gmt":"2024-07-02T17:15:31","slug":"technical-preview-database-experimentation-assistant","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/","title":{"rendered":"Technical Preview: Database Experimentation Assistant"},"content":{"rendered":"<p><em>This post is authored by Christina Lee, Program Manager &#8211; Data Group SEALS Team<\/em><\/p>\n<h3>Overview<\/h3>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=54090\">Database Experimentation Assistant (DEA)<\/a> is a new A\/B testing solution for SQL Server upgrades. It will assist in evaluating a targeted version of SQL for a given workload. Customers upgrading from previous SQL server versions (starting 2005 and above) to any new version of the SQL server can use these analysis metrics provided by tool, such as queries that have compatibility errors, degraded queries, query plans, and other workload comparison data to build higher confidence and have a successful upgrade experience.<\/p>\n<h3>What Can I Do?<\/h3>\n<p>DEA offers the following capabilities for workload comparison analysis and reporting:<\/p>\n<ul>\n<li>Set up automated <strong>workload capture and replay<\/strong> of production database (using existing SQL server functionality Distributed Replay &amp; SQL tracing)<\/li>\n<li>Perform <strong>statistical analysis<\/strong> on traces collected using both old and new instances<\/li>\n<li>Visualize data through <strong>analysis report<\/strong> via rich user experience<\/li>\n<\/ul>\n<p>With DEA, you can:<\/p>\n<ul>\n<li>Capture Trace: you can automatically capture a production workload trace with only a few inputs. Learn how to <a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2016\/10\/25\/database-experimentation-assistant-capture-trace\/\">capture trace<\/a>.<\/li>\n<li>Replay Trace: you can replay a trace on current and new\/proposed instances of SQL. Learn how to <a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2016\/10\/25\/database-experimentation-assistant-replay-trace\/\">replay trace<\/a>.<\/li>\n<li>View Workload Analysis Reports: you can generate new reports to gain insights on how workload performance changes across versions of SQL. In addition to generating a new report, you can view previously generated reports. Learn how to <a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2016\/10\/25\/database-experimentation-assistant-workload-analysis-reports\/\">generate reports<\/a>.<\/li>\n<\/ul>\n<p>DEA can be used through command line: learn how to use <a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2016\/10\/25\/database-experimentation-assistant-command-line\/\">DEA command line<\/a>.<\/p>\n<h3>Supported versions<\/h3>\n<p>Source: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, and SQL Server 2016<br \/>\nTarget: SQL Server 2012, SQL Server 2014, and SQL Server 2016<\/p>\n<h3>Installation<\/h3>\n<p>You can install from <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=54090\">Microsoft Download Center<\/a>. Run \u2018DatabaseExperimentationAssistant.msi\u2019 to install Database Experimentation Assistant.<\/p>\n<h3>Questions\/Feedback<\/h3>\n<p>For questions, please visit the <a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2016\/10\/25\/database-experimentation-assistant-faq\/\">FAQs for DEA<\/a>. If you have further questions or would like to provide feedback, please email us at <a href=\"mailto:deafeedback@microsoft.com\">deafeedback@microsoft.com<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post is authored by Christina Lee, Program Manager &#8211; Data Group SEALS Team Overview Database Experimentation Assistant (DEA) is a new A\/B testing solution for SQL Server upgrades. It will assist in evaluating a targeted version of SQL for a given workload.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-17785","post","type-post","status-publish","format-standard","hentry","content-type-updates","review-flag-1593580427-503","review-flag-1593580414-58","review-flag-dea-1593580492-742","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Technical Preview: Database Experimentation Assistant - Microsoft SQL Server Blog<\/title>\n<meta name=\"description\" content=\"November 2016 Technical Preview: Database Experimentation Assistant.\" \/>\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.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Technical Preview: Database Experimentation Assistant - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"November 2016 Technical Preview: Database Experimentation Assistant.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2016-11-22T17:00:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-02T17:15:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Technical Preview: Database Experimentation Assistant\",\"datePublished\":\"2016-11-22T17:00:51+00:00\",\"dateModified\":\"2024-07-02T17:15:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/\"},\"wordCount\":323,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/\",\"name\":\"Technical Preview: Database Experimentation Assistant - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2016-11-22T17:00:51+00:00\",\"dateModified\":\"2024-07-02T17:15:31+00:00\",\"description\":\"November 2016 Technical Preview: Database Experimentation Assistant.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Technical Preview: Database Experimentation Assistant\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Technical Preview: Database Experimentation Assistant - Microsoft SQL Server Blog","description":"November 2016 Technical Preview: Database Experimentation Assistant.","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.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/","og_locale":"en_US","og_type":"article","og_title":"Technical Preview: Database Experimentation Assistant - Microsoft SQL Server Blog","og_description":"November 2016 Technical Preview: Database Experimentation Assistant.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2016-11-22T17:00:51+00:00","article_modified_time":"2024-07-02T17:15:31+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"1 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Technical Preview: Database Experimentation Assistant","datePublished":"2016-11-22T17:00:51+00:00","dateModified":"2024-07-02T17:15:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/"},"wordCount":323,"commentCount":4,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/","name":"Technical Preview: Database Experimentation Assistant - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2016-11-22T17:00:51+00:00","dateModified":"2024-07-02T17:15:31+00:00","description":"November 2016 Technical Preview: Database Experimentation Assistant.","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/11\/22\/technical-preview-database-experimentation-assistant\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Technical Preview: Database Experimentation Assistant"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/17785","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=17785"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/17785\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=17785"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=17785"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=17785"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=17785"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=17785"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=17785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}