{"id":19405,"date":"2017-03-31T09:00:00","date_gmt":"2017-03-31T16:00:00","guid":{"rendered":""},"modified":"2024-07-02T10:14:43","modified_gmt":"2024-07-02T17:14:43","slug":"technical-preview-database-experimentation-assistant-2","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/","title":{"rendered":"Technical Preview: Database Experimentation Assistant"},"content":{"rendered":"<p><em>This post was authored by Christina Lee, Program Manager &#8211; SEALS Team<\/em><\/p>\n<h2>Overview<\/h2>\n<p>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. Customers who are upgrading from previous SQL Server versions (SQL Server 2005 and above) to any new version of SQL Server will be able to use these analysis metrics provided, such as queries that have compatibility errors, degraded queries, query plans, and other workload comparison data, to help them build higher confidence, making it a successful upgrade experience.<\/p>\n<h2>What is new?<\/h2>\n<p>DEA 2.0 is a major version update and includes the following improvements:<\/p>\n<ul>\n<ul>\n<li>\n<b>Bundled installation of DEA dependencies<\/b><b>:<\/b> Installation is simplified by bundling all dependencies (barring <a href=\"https:\/\/github.com\/Microsoft\/R-Interop\">R-Interop<\/a> and <a href=\"https:\/\/cran.r-project.org\/bin\/windows\/base\/\">CRAN<\/a>) with DEA installer. Note that DReplay setup is assumed to be available to run replay.<\/li>\n<li>\n<b>Support for multiple captures and replay from the UI<\/b><b>:<\/b> DEA UI now supports the ability to start multiple captures and replay. Please refer to <a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2017\/03\/24\/dea-2-0-how-to-use-database-experimentation-assistant\/\">How to capture workload using DEA<\/a> for details.<\/li>\n<li>\n<b>Simplified replay through DEA UI<\/b><b>:<\/b> Number of steps required to start a replay is reduced from three to one. DEA will also show status from DReplay controller as well as all the clients. Please refer to\u00a0 <a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2017\/03\/24\/dea-2-0-how-to-use-database-experimentation-assistant\/\">How to replay workload using DEA for<\/a> details.<\/li>\n<li>\n<b>Revamped user interface for analysis<\/b><b>:<\/b> This version includes a more intuitive UI for tools and especially analysis reports.<\/li>\n<li>\n<b>Bug fixes from DEA 1.0: <\/b>Many customer-reported bugs are fixed as part of this release. This includes fix for errors occurring while capturing in SQL Server 2005 and errors seen while in the Replay and Analysis steps.<\/li>\n<li>\n<b>Feedback UI<\/b><b>:<\/b> Customers can now submit feedback through a simple UI in DEA.<\/li>\n<\/ul>\n<\/ul>\n<h3>Other documents\/tutorials?<\/h3>\n<p>The following documents give a step-by-step guide to leverage DEA 2.0 for workload comparison<\/p>\n<ul>\n<li><a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2017\/03\/23\/database-experimentation-assistant-2-0-solution-architecture-to-compare-workloads\/\">Solution architecture to compare workloads using DEA<\/a><\/li>\n<li><a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2017\/03\/24\/dea-2-0-how-to-use-database-experimentation-assistant\/\">How to use DEA 2.0<\/a><\/li>\n<li><a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2017\/03\/22\/dea-2-0-configure-replay-environment\/\">How to configure replay environment and common issues<\/a><\/li>\n<li><a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2017\/03\/24\/dea-2-0-capture-trace-faq\/\">Common issues and solutions while capturing workload<\/a><\/li>\n<li><a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2017\/03\/24\/dea-2-0-replay-faq\/\">Common issues and solutions while replaying workloads<\/a><\/li>\n<li><a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2017\/03\/24\/dea-2-0-analysis-faq\/\">Common issues and solutions while analyzing workloads<\/a><\/li>\n<li><a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2017\/03\/24\/dea-2-0-updating-db-schema-for-analysis-report-in-the-database-experimentation-assistant\/\">Upgrade existing analysis schema<\/a><\/li>\n<li><a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2016\/10\/25\/database-experimentation-assistant-command-line\/\">Using DEA 2.0 from command line<\/a><\/li>\n<\/ul>\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 DatabaseExperimentationAssistant.exe to install Database Experimentation Assistant tool.<\/p>\n<h2>Existing features<\/h2>\n<p><a href=\"https:\/\/blogs.msdn.microsoft.com\/datamigration\/2016\/10\/24\/database-experimentation-assistant-v1-0-preview\/\">Database Experimentation Assistant (DEA) v1.0<\/a><\/p>\n<h2>Supported sources and target versions<\/h2>\n<p>Source: SQL Server 2005 and above<\/p>\n<p>Target: SQL Server 2005 and above<\/p>\n<p>Analysis: SQL Server 2008 and above<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post was authored by Christina Lee, Program Manager &#8211; 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":[5227,2406],"content-type":[2448],"topic":[2475],"coauthors":[2487],"class_list":["post-19405","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2017","content-type-updates","topic-oltp-database-management","review-flag-1593580427-503","review-flag-1-1593580431-15","review-flag-2-1593580436-981","review-flag-dea-1593580492-742","review-flag-lever-1593580264-545","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=\"March 2017 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\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/\" \/>\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=\"March 2017 Technical Preview: Database Experimentation Assistant.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/\" \/>\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=\"2017-03-31T16:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-02T17:14:43+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=\"2 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\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/\"},\"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\":\"2017-03-31T16:00:00+00:00\",\"dateModified\":\"2024-07-02T17:14:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/\"},\"wordCount\":400,\"commentCount\":1,\"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\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/\",\"name\":\"Technical Preview: Database Experimentation Assistant - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2017-03-31T16:00:00+00:00\",\"dateModified\":\"2024-07-02T17:14:43+00:00\",\"description\":\"March 2017 Technical Preview: Database Experimentation Assistant.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/#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":"March 2017 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\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/","og_locale":"en_US","og_type":"article","og_title":"Technical Preview: Database Experimentation Assistant - Microsoft SQL Server Blog","og_description":"March 2017 Technical Preview: Database Experimentation Assistant.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2017-03-31T16:00:00+00:00","article_modified_time":"2024-07-02T17:14:43+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":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/"},"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":"2017-03-31T16:00:00+00:00","dateModified":"2024-07-02T17:14:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/"},"wordCount":400,"commentCount":1,"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\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/","name":"Technical Preview: Database Experimentation Assistant - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2017-03-31T16:00:00+00:00","dateModified":"2024-07-02T17:14:43+00:00","description":"March 2017 Technical Preview: Database Experimentation Assistant.","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2017\/03\/31\/technical-preview-database-experimentation-assistant-2\/#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\/19405","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=19405"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/19405\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=19405"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=19405"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=19405"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=19405"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=19405"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=19405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}