Microsoft SQL Server Distributed Replay (Troubleshooting) Part 6 :

  While running the Distributed Replay i ran into couple of issues listed below.   How long the trace should be left running? Running trace should be well planned with Support/Dev/QA team to generate the peak load which is used to set the benchmark for the application/website.The trace should include heavy insert/update/delete/Long running queries/business reports. […]

Microsoft SQL Server Distributed Replay Part 5

In this post we will see on how to replay the preprocess file to target sql server. I have 2 Distributed Replay Clients on 2 different machine   dreplay replay -s Target SQL Server Instance Name -w DestinationSqlinstance1, DestinationSqlinstance2 -f 20 -d ‘C:\DatabaseMigration\ReplayTrace’ -o

Microsoft SQL Server Distributed Replay Part 4

Setup the SS replay trace on the Source SQL Server Server. I have create the SST for easy use To run the above trace in QA after having much planning and discussion with Application team / QA Team to generate maximum load. After 2 hour of trace running and capturing events i end up with […]

Microsoft SQL Server Distributed Replay Part 3

Once the configuration is done,grant proper permission to users to access the Controller and the Client. To grant permission open comexp.msc from run and navigate and shown in below image     Right click DReplayController Service and select properties     Navigate to the Security Tab and click Edit under Launch ad Activate Permission   […]

Microsoft SQL Server Distributed Replay Part 2

Configure SQL Server Distributed Replay Controller and SQL Server Distributed Replay Client.Start the Distributed Replay Controller and SQL Server Distributed Replay Client services after the installation.   The Default location of Distributed Replay is C:Program Files (x86)Microsoft SQL Server120Tools Check the Display Controller log files for the Controller Status (C:Program Files (x86)Microsoft SQL Server120ToolsDReplayControllerLog) Check […]

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 […]