In SQL Server 2014, dreplay.exe was available under "Management Tools – Basic" feature. However, in SQL Server 2017 that feature no longer exists (Enterprise edition) and it doesn't come with SSMS installer either. Here is what available from SQL Server 2017 installer:

enter image description here

Did they move dreplay.exe somewhere else?

Any help is much appreciated!

Update 1.

It seems there is a bit of confusion around Distributed Replay and what exactly I am looking for. So I thought to include a diagram from this article:

enter image description here

Administration tool (dreplay.exe) is what I am looking for.

Controller (DReplayController.exe) is Distributed Replay Controller from feature selection screen. It is useless without Administration tool.

Client (DReplayClient.exe) is Distributed Replay Client from feature selection screen. It is useless without Controller.

Update 2.

OS: Windows Server 2016 Standard

SQL Server Management Studio version: 18.4 **

** (As this post suggests dreplay.exe came with SSMS 17.x, but got removed from 18.x)

SQL Server < Shared Components > version: 14.0.1000.169 ***

*** (displayed at Installation Type step or can be found in MediaInfo.xml Property Id="BaselineVersion" that is located in the root of disk with SQL Server installer)

Binn folder contents:

 Directory of C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn

18/11/2019  15:19    <DIR>          .
18/11/2019  15:19    <DIR>          ..
18/11/2019  15:19    <DIR>          DQ
22/08/2017  18:39           697,528 DReplayCommon.dll
22/08/2017  18:39            20,592 DReplayServer.tlb
22/08/2017  18:40            32,952 DReplayServerPS.dll
04/11/2019  15:25    <DIR>          Resources
04/11/2019  15:28    <DIR>          schemas
15/06/2019  11:09           602,848 SqlManager.dll
22/08/2017  18:47            60,088 SQLPS.exe
22/08/2017  18:48               379 SQLPS.exe.config
15/06/2019  11:09            29,472 sqlresld.dll
15/06/2019  11:09            29,264 SqlResourceLoader.dll
15/06/2019  11:08            59,672 SQLSCM.DLL
15/06/2019  11:08           133,200 SQLSVC.DLL
              10 File(s)      1,665,995 bytes
               5 Dir(s)  97,550,450,688 bytes free
  • 1
    I see "Distributed Replay Controller" and "Distributed Replay Client" in the screen image under Shared Features. Looks like it is already installed. – Dan Guzman Nov 18 at 19:58
  • @DanGuzman unfortunately, there is a 3rd thing - Distributed Replay itself (not Controller or Client), it is designed to allow to control Controller via CMD. Without Distributed Replay, you cannot use Controller – Vladimirs Nov 19 at 14:13
  • 1
    @Vladimirs thanks for the update. When installing client and controller on SQL Server 2017 I do find DReplay.exe in my default location of C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn – Randi Vertongen Nov 20 at 11:52
  • 1
    @RandiVertongen is it definitely comes out of SQL Server installer? Maybe you have SSMS 17.x installed (i've put a link in my 2nd update where it suggests that dreplay.exe used to come with SSMS 17.x). If you do not have SSMS 17.x, would you be so kind to check your < Shared Components > version? – Vladimirs Nov 20 at 12:59
  • 1
    You are right about the 17.x, my bad! Nicely spotted. – Randi Vertongen Nov 20 at 13:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.