Sql Server 2012 Distributed Replay Features

Distributed Replay is a new feature that can help make an assessment ( assessment) the impact of a SQL Server upgrade process , hardware , operating system or the SQL Server Tunning .

Its function is similar ( identical ) to the SQL Server Profiler , the main difference is , load analysis ( impact ) with Distributed Replay can be performed on many servers (client ) , not only on one machine as the Profiler . Besides being able to perform Trace on some systems , Distributed Replay can also perform analysis on the environment that is ‘ Mission Critical ‘ .

You can use the Distributed Replay to replay the captured trace against the test environment upgrade . Unlike SQL Server Profiler , Distributed Replay unlimited play workload of a computer .

Distributed Replay offers a more scalable solution than SQL Server Profiler . With Distributed Replay , you can replay the workload from multiple computers and better simulate mission-critical workloads .

Microsoft SQL Server Distributed Replay feature can use multiple computers to replay trace data and simulate a mission-critical workloads . Use the Distributed Replay for application compatibility testing , performance testing , or capacity planning .

When Using Distributed Replay

You can use SQL Server Profiler to replay a captured trace against the test environment upgrade . Right conditions for use Distributed Replay :

Evaluation of application compatibility , such as going to upgrade SQL Servers , hardware , or index tunning .
Execution simultaneously ( concurrency ) is very high , so that a single replay of a machine can not be sufficient .
Distributed Replay Concepts

The following components make Distributed Replay environment :

Distributed Replay controller : A computer running Windows service named SQL Server Distributed Replay controller . The Distributed Replay controller orchestrates the actions of clients distributed replications . There is only one example of the controller in each Distributed Replay environment .
Distributed Replay administration tool : A console application , DReplay.exe , used to communicate with the distributed replay controller . Use the administration tool to control the distributed replay .
Target server : An instance of SQL Server Distributed Replay client that can be used to replay the trace data . We recommend that the target server is in a test environment .
Distributed Replay Client : One or more computer ( physical or virtual ) running the Windows service named SQL Server Distributed Replay client . Distributed Replay client work together to simulate the workload on the instance of . There are one or more clients in every Distributed Replay environment .
The Distributed Replay administration controller, tool , and the client can be installed on a different computer or the same computer . There is only one instance of the Distributed Replay controller or client service running on the same computer

Related Posts