Home > Distributed Replay > Microsoft SQL Server Distributed Replay Part 1

Microsoft SQL Server Distributed Replay Part 1

 

The Microsoft SQL Server Distributed Replay feature helps you assess the impact of future SQL Server upgrades. You can also use it to help assess the impact of hardware and operating system upgrades, and SQL Server tuning.

SQL Server Distributed Replay is introduced with SQL Server 2012 (E.E).Works with SQL Server 2005 and later.

This can be installed independently of SQL Server Engine.

1. SQL Server Distributed Replay Controller
SQL Server Controller will be used to process the trace file and generate the replay processed files.

2. SQL Server Distributed Replay Client
SQL Server Client should be connected to the Controller. As these will be used to replay the processed files to the Target SQL Server.

 

Pre-requisites for installing Distributed Replay Component

 

Service Account for component Services

If you use more than 1 Distributed Replay client on multiple machines the same account should be used to connect the Distributed Replay Controller.

Distributed Replay Installation and Configuration

Install the Distributor Replay Controller and Client .

clip_image001

In the Distributed Replay Client Setup, The Controller Server name will be the Server name of the Distributed Replay Controller.

clip_image002

For more than 1 client, just install the Distributed Replay Client feature.

After the Installation Start the Services on Controller server and Client Services

Controller Server

NET STOP "SQL Server Distributed Replay Controller" 
NET STOP "SQL Server Distributed Replay Client" 
NET START "SQL Server Distributed Replay Controller" 
NET START "SQL Server Distributed Replay Client"

Client Server

NET STOP "SQL Server Distributed Replay Client" 
NET START "SQL Server Distributed Replay Client"

Categories: Distributed Replay
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: