{"id":508,"date":"2011-11-09T02:00:00","date_gmt":"2011-11-09T02:00:00","guid":{"rendered":"\/blogs\/jonathan\/post\/Installing-and-Configuring-SQL-Server-2012-Distributed-Replay.aspx"},"modified":"2017-04-13T12:13:26","modified_gmt":"2017-04-13T16:13:26","slug":"installing-and-configuring-sql-server-2012-distributed-replay","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/","title":{"rendered":"Installing and Configuring SQL Server 2012 Distributed Replay"},"content":{"rendered":"

\nThis blog post is the first in a series of posts that will cover how to install, configure, and use the new Distributed Replay Utility in SQL Server 2012.  The distributed replay utility can be used to assess the impact of changes and upgrades by replaying workload activity against a test environment based on a replay trace captured from the current production SQL Server environment.  Prior to SQL Server 2012, two features existed that provided replay capabilities for performance benchmarking and stress testing SQL Server based on a replay workload; SQL Server Profiler trace replay and RML Utilities.  Unlike these two tools, Distributed Replay is not limited to replaying events from a single computer, which allows you to drive higher loads against the test environment to better simulate mission-critical workloads by driving load from multiple clients concurrently.\n<\/p>\n

\nThis blog post will show how to configure a Distributed Replay Controller, using a dedicated server named SQL2012-DRU, and two Distributed Replay Clients using dedicated servers named SQL2012-DRU1 and SQL2012-DRU2.  For the purposes of performing an actual replay using Distributed Replay in another post, a separate server named SQL2012-DB1 with the Database Engine Services and the AdventureWorks2008R2 database installed on it will be used.\n<\/p>\n

Create Replay Service Accounts in Active Directory<\/h1>\n

\nThe first step in installing and configuring Distributed Replay is to setup the necessary Active Directory service accounts to run the Distributed Replay Client and Distributed Replay Controller under.  For the purposes of service isolation, the Distributed Replay Clients and Distributed Replay Controller will make use of separate Active Directory service Accounts.  For the purposes of this blog post, two different accounts will be created.  The Distributed Replay Client will use the SQLskillsDemos\\DRUClientSvcAcct as shown in the below screenshots.\n<\/p>\n

\n\"image\"<\/a>\n<\/p>\n

\nThe Distributed Replay Controller will use the SQLskillsDemos\\DRUCtrlSvcAcct as shown in the below screenshots:\n<\/p>\n

\n\"image\"<\/a>\n<\/p>\n

Install the Replay Controller<\/h1>\n

\nWith the service accounts setup in Active Directory, we can begin the installation of our Distributed Replay Controller.  To do this run SQL Server 2012 Setup on the controller and perform a SQL Server Feature Installation<\/strong>.  On the Feature Selection<\/strong> page select the Distributed Replay Client<\/strong> feature.\n<\/p>\n

\n\"image\"<\/a>\n<\/p>\n

\nOn the Server Configuration<\/strong> page set the Service Account credentials to the previously created Active Directory account for the client; in this case SQLSKILLSDEMOS\\DRUCtrlSvcAcct.\n<\/p>\n

\n\"image\"<\/a>\n<\/p>\n

\nOn the Distributed Replay Controller<\/strong> page, click the Add<\/strong> button and search directory services for the client service account previous created in Active Directory; in this case SQLSKILLSDEMOS\\DRUClientSvcAcct.\n<\/p>\n

\n\"image\"<\/a>\n<\/p>\n

\nFinish the installation and then close SQL Server Setup.\n<\/p>\n

Install the Replay Clients<\/h1>\n

\nWith the service accounts setup in Active Directory, we can begin the installation of our Distributed Replay Client machines.  To do this run SQL Server 2012 Setup on each of the clients to be configured and perform a SQL Server Feature Installation<\/strong>.  On the Feature Selection<\/strong> page select the Distributed Replay Client<\/strong> feature.\n<\/p>\n

\n\"image\"<\/a>\n<\/p>\n

\nOn the Server Configuration<\/strong> page set the Service Account credentials to the previously created Active Directory account for the client.  In this case SQLSKILLSDEMOS\\DRUClientSvcAcct.\n<\/p>\n

\n\"image\"<\/a>\n<\/p>\n

\nOn the Distributed Replay Client<\/strong> page, type in the name of the server that you previously installed the Distributed Replay Controller service on in the Controller Name<\/strong> box.\n<\/p>\n

\n\"image\"<\/a>\n<\/p>\n

\nFinish the installation and then close SQL Server Setup.\n<\/p>\n

Configure the Windows Firewall for the Services<\/h1>\n

\nIn order for the Distributed Replay Clients (SQL2012-DRU1 and SQL2012-DRU2) to connect and register with the Distributed Replay Controller, in this case SQL2012-DRU, the firewall must be configured to allow inbound connections for the DReplayClient.exe application on each of the client machines, as well as for the DReplayController.exe application on the Distributed Replay Controller.  To do this, firewall rules need to be added through the use of the Windows Firewall with Advanced Security snapin, available through Start | Administrative Tools | Windows Firewall with Advanced Security, <\/strong>or through the use of NETSH command line statement executions (detailed later in this blog post). \n<\/p>\n

\nTo add a new firewall rule for the DReplay Client using the Windows Firewall with Advanced Security<\/strong> snapin, Right-Click<\/strong> on Inbound Rules<\/strong> and click on the New Rule<\/strong> menu item.  Specify Program<\/strong> for the Rule Type<\/strong> and click Next<\/strong>.\n<\/p>\n

\n\"image\"<\/a>\n<\/p>\n

\nOn the Program<\/strong> page, click Browse<\/strong> and navigate to C:\\Program Files (x86)\\Microsoft SQL Server\\110\\Tools\\DReplayClien<\/strong>t and select the DReplayClient.exe<\/strong> executable.\n<\/p>\n

\n\"image\"<\/a>\n<\/p>\n

\nOn the Action<\/strong> page select the option Allow the connection<\/strong> and then click Next<\/strong>.\n<\/p>\n

\n\"image\"<\/a>\n<\/p>\n

\nOn the Profile<\/strong> page, select the appropriate network profiles\/locations for the environment, generally Domain<\/strong> would be sufficient for most corporate domains, and then click Next<\/strong>.\n<\/p>\n

\n\"image\"<\/a>\n<\/p>\n

\nFinally provide a Name<\/strong> for the rule and click Finish<\/strong> to make the firewall changes.\n<\/p>\n

\n\"image\"<\/a>\n<\/p>\n

\nTo setup the firewall rule for the Distributed Replay Controller, follow the same steps but instead of selecting the DReplayClient<\/strong> folder and DReplayClient.exe<\/strong> application, select the DReplayController<\/strong> folder and DReplayController.exe<\/strong> application\n<\/p>\n

\n\"image\"<\/a>\n<\/p>\n

\nThese rules can also be added using NETSH<\/strong> from the command line using the following commands:\n<\/p>\n

\n

\n\tNETSH advfirewall firewall add rule name="Allow DReplay Client" dir=in program="C:\\Program Files (x86)\\Microsoft SQL Server\\110\\Tools\\DReplayClient\\DReplayClient.exe" action=allow\n\t<\/p>\n

\n\tNETSH advfirewall firewall add rule name="Allow DReplay Controller" dir=in program="C:\\Program Files (x86)\\Microsoft SQL Server\\110\\Tools\\DReplayController\\DReplayController.exe" action=allow\n\t<\/p>\n<\/blockquote>\n

Start the Services and Verify Client Registrations<\/h1>\n

\nThe final step in the process of installing and configuring SQL Server 2012 Distributed Replay is to start the services and verify that the Distributed Replay Clients register with the Distributed Replay Controller correctly.  To do this start the “Distributed Replay Controller”<\/strong> service from the Services.msc<\/strong> snap-in or from the command line using NET START <\/strong>on the controller server.<\/strong>  Then start the “Distributed Replay Client” <\/strong>service on from the Services.msc<\/strong> snap-in or from the command line using NET START<\/strong> on each of the client machines.  As each of the client services starts, verify that the client was able to successfully register itself with the controller by reading the log file, which is located in the following path:\n<\/p>\n

\n

\n\tC:\\Program Files (x86)\\Microsoft SQL Server\\110\\Tools\\DReplayClient\\Log\n\t<\/p>\n<\/blockquote>\n

\nWhat you want to see in the DReplay Client Log file is:\n<\/p>\n

\n

\n\t2011-11-09 00:41:09:162 OPERATIONAL  [Client Service]      Microsoft SQL Server Distributed Replay Client – 11.0.1440.19.
\n\t2011-11-09 00:41:09:162 OPERATIONAL  [Client Service]      (c) Microsoft Corporation.
\n\t2011-11-09 00:41:09:162 OPERATIONAL  [Client Service]      All rights reserved.
\n\t2011-11-09 00:41:09:178 OPERATIONAL  [Client Service]      Current edition is: [Enterprise Evaluation Edition].
\n\t2011-11-09 00:41:09:178 OPERATIONAL  [Common]              Initializing dump support.
\n\t2011-11-09 00:41:09:178 OPERATIONAL  [Common]              Dump support is ready.
\n\t2011-11-09 00:41:09:193 OPERATIONAL  [Client Service]      Windows service "Microsoft SQL Server Distributed Replay Client" has started under service account "SQLSKILLSDEMOS\\DRUClientSvcAcct". Process ID is 2928.
\n\t2011-11-09 00:41:09:193 OPERATIONAL  [Client Service]      Time Zone: Eastern Standard Time.
\n\t2011-11-09 00:41:09:193 OPERATIONAL  [Client Service]      Controller name is "SQL2012-DRU".
\n\t2011-11-09 00:41:09:193 OPERATIONAL  [Client Service]      Working directory is "C:\\Program Files (x86)\\Microsoft SQL Server\\110\\Tools\\DReplayClient\\WorkingDir".
\n\t2011-11-09 00:41:09:193 OPERATIONAL  [Client Service]      Result directory is "C:\\Program Files (x86)\\Microsoft SQL Server\\110\\Tools\\DReplayClient\\ResultDir".
\n\t2011-11-09 00:41:09:193 OPERATIONAL  [Client Service]      Heartbeat Frequency(ms): 3000
\n\t2011-11-09 00:41:09:193 OPERATIONAL  [Client Service]      Heartbeats Before Timeout: 3
\n\t2011-11-09 00:41:09:367 OPERATIONAL  [Client Service]      Registered with controller "SQL2012-DRU".
\n\t<\/strong>\n\t<\/p>\n<\/blockquote>\n

\nWhat you don’t want to see in the DReplay Client Log file is:\n<\/p>\n

\n

\n\t2011-11-09 00:40:50:207 OPERATIONAL  [Client Service]      Microsoft SQL Server Distributed Replay Client – 11.0.1440.19.
\n\t2011-11-09 00:40:50:223 OPERATIONAL  [Client Service]      (c) Microsoft Corporation.
\n\t2011-11-09 00:40:50:223 OPERATIONAL  [Client Service]      All rights reserved.
\n\t2011-11-09 00:40:50:223 OPERATIONAL  [Client Service]      Current edition is: [Enterprise Evaluation Edition].
\n\t2011-11-09 00:40:50:223 OPERATIONAL  [Common]              Initializing dump support.
\n\t2011-11-09 00:40:50:239 OPERATIONAL  [Common]              Dump support is ready.
\n\t2011-11-09 00:40:50:239 OPERATIONAL  [Client Service]      Windows service "Microsoft SQL Server Distributed Replay Client" has started under service account "SQLSKILLSDEMOS\\DRUClientSvcAcct". Process ID is 776.
\n\t2011-11-09 00:40:50:239 OPERATIONAL  [Client Service]      Time Zone: Eastern Standard Time.
\n\t2011-11-09 00:40:50:239 OPERATIONAL  [Client Service]      Controller name is "SQL2012-DRU".
\n\t2011-11-09 00:40:50:239 OPERATIONAL  [Client Service]      Working directory is "C:\\Program Files (x86)\\Microsoft SQL Server\\110\\Tools\\DReplayClient\\WorkingDir".
\n\t2011-11-09 00:40:50:239 OPERATIONAL  [Client Service]      Result directory is "C:\\Program Files (x86)\\Microsoft SQL Server\\110\\Tools\\DReplayClient\\ResultDir".
\n\t2011-11-09 00:40:50:239 OPERATIONAL  [Client Service]      Heartbeat Frequency(ms): 3000
\n\t2011-11-09 00:40:50:239 OPERATIONAL  [Client Service]      Heartbeats Before Timeout: 3
\n\t2011-11-09 00:40:50:476 CRITICAL     [Client Service]     [0xC8100013] Failed to register with controller SQL2012-DRU.
\n\t<\/strong>\n\t<\/p>\n<\/blockquote>\n

\nIf the client fails to register, and the controller name is correct, you need to verify first that the firewall rules have been established for the client to allow the appropriate inbound connections from the controller service and that the firewall rules have been established for the controller to allow the appropriate inbound connections from the client services.  If this all checks out, you need to go troubleshoot the permissions and setup of the services in the environment, which I’ll cover in a later post.<\/p>\n","protected":false},"excerpt":{"rendered":"

This blog post is the first in a series of posts that will cover how to install, configure, and use the new Distributed Replay Utility in SQL Server 2012.  The distributed replay utility can be used to assess the impact of changes and upgrades by replaying workload activity against a test environment based on a […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,21,39,40],"tags":[],"class_list":["post-508","post","type-post","status-publish","format-standard","hentry","category-benchmarking","category-distributed-replay","category-sql-server-2012","category-sql-server-denali"],"yoast_head":"\nInstalling and Configuring SQL Server 2012 Distributed Replay - Jonathan Kehayias<\/title>\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.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installing and Configuring SQL Server 2012 Distributed Replay - Jonathan Kehayias\" \/>\n<meta property=\"og:description\" content=\"This blog post is the first in a series of posts that will cover how to install, configure, and use the new Distributed Replay Utility in SQL Server 2012.  The distributed replay utility can be used to assess the impact of changes and upgrades by replaying workload activity against a test environment based on a […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/\" \/>\n<meta property=\"og:site_name\" content=\"Jonathan Kehayias\" \/>\n<meta property=\"article:published_time\" content=\"2011-11-09T02:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T16:13:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/installing-and-configuring-sql-server-20\/439b1391\/image_thumb.png\" \/>\n<meta name=\"author\" content=\"Jonathan Kehayias\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathan Kehayias\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/installing-and-configuring-sql-server-2012-distributed-replay\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/installing-and-configuring-sql-server-2012-distributed-replay\\\/\"},\"author\":{\"name\":\"Jonathan Kehayias\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"headline\":\"Installing and Configuring SQL Server 2012 Distributed Replay\",\"datePublished\":\"2011-11-09T02:00:00+00:00\",\"dateModified\":\"2017-04-13T16:13:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/installing-and-configuring-sql-server-2012-distributed-replay\\\/\"},\"wordCount\":1698,\"commentCount\":3,\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/installing-and-configuring-sql-server-2012-distributed-replay\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/installing-and-configuring-sql-server-20\\\/439b1391\\\/image_thumb.png\",\"articleSection\":[\"Benchmarking\",\"Distributed Replay\",\"SQL Server 2012\",\"SQL Server Denali\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/installing-and-configuring-sql-server-2012-distributed-replay\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/installing-and-configuring-sql-server-2012-distributed-replay\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/installing-and-configuring-sql-server-2012-distributed-replay\\\/\",\"name\":\"Installing and Configuring SQL Server 2012 Distributed Replay - Jonathan Kehayias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/installing-and-configuring-sql-server-2012-distributed-replay\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/installing-and-configuring-sql-server-2012-distributed-replay\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/installing-and-configuring-sql-server-20\\\/439b1391\\\/image_thumb.png\",\"datePublished\":\"2011-11-09T02:00:00+00:00\",\"dateModified\":\"2017-04-13T16:13:26+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/installing-and-configuring-sql-server-2012-distributed-replay\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/installing-and-configuring-sql-server-2012-distributed-replay\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/installing-and-configuring-sql-server-2012-distributed-replay\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/installing-and-configuring-sql-server-20\\\/439b1391\\\/image_thumb.png\",\"contentUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/installing-and-configuring-sql-server-20\\\/439b1391\\\/image_thumb.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/installing-and-configuring-sql-server-2012-distributed-replay\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Benchmarking\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/category\\\/benchmarking\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Installing and Configuring SQL Server 2012 Distributed Replay\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\",\"name\":\"Jonathan Kehayias - The Rambling DBA\",\"description\":\"The Rambling DBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\",\"name\":\"Jonathan Kehayias\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"caption\":\"Jonathan Kehayias\"},\"sameAs\":[\"http:\\\/\\\/3.209.169.194\\\/blogs\\\/jonathan\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Installing and Configuring SQL Server 2012 Distributed Replay - Jonathan Kehayias","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.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/","og_locale":"en_US","og_type":"article","og_title":"Installing and Configuring SQL Server 2012 Distributed Replay - Jonathan Kehayias","og_description":"This blog post is the first in a series of posts that will cover how to install, configure, and use the new Distributed Replay Utility in SQL Server 2012.  The distributed replay utility can be used to assess the impact of changes and upgrades by replaying workload activity against a test environment based on a […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/","og_site_name":"Jonathan Kehayias","article_published_time":"2011-11-09T02:00:00+00:00","article_modified_time":"2017-04-13T16:13:26+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/installing-and-configuring-sql-server-20\/439b1391\/image_thumb.png","type":"","width":"","height":""}],"author":"Jonathan Kehayias","twitter_misc":{"Written by":"Jonathan Kehayias","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/"},"author":{"name":"Jonathan Kehayias","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"headline":"Installing and Configuring SQL Server 2012 Distributed Replay","datePublished":"2011-11-09T02:00:00+00:00","dateModified":"2017-04-13T16:13:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/"},"wordCount":1698,"commentCount":3,"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/installing-and-configuring-sql-server-20\/439b1391\/image_thumb.png","articleSection":["Benchmarking","Distributed Replay","SQL Server 2012","SQL Server Denali"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/","name":"Installing and Configuring SQL Server 2012 Distributed Replay - Jonathan Kehayias","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/installing-and-configuring-sql-server-20\/439b1391\/image_thumb.png","datePublished":"2011-11-09T02:00:00+00:00","dateModified":"2017-04-13T16:13:26+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/installing-and-configuring-sql-server-20\/439b1391\/image_thumb.png","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/installing-and-configuring-sql-server-20\/439b1391\/image_thumb.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/installing-and-configuring-sql-server-2012-distributed-replay\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/"},{"@type":"ListItem","position":2,"name":"Benchmarking","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/category\/benchmarking\/"},{"@type":"ListItem","position":3,"name":"Installing and Configuring SQL Server 2012 Distributed Replay"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/","name":"Jonathan Kehayias - The Rambling DBA","description":"The Rambling DBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c","name":"Jonathan Kehayias","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","caption":"Jonathan Kehayias"},"sameAs":["http:\/\/3.209.169.194\/blogs\/jonathan"]}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/508","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/comments?post=508"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/508\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/media?parent=508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/categories?post=508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/tags?post=508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}