Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

RML Utilities for SQL2016 and SQL2017 #49

Open
OctavianCC opened this issue Oct 20, 2017 · 5 comments

Comments

@OctavianCC
Copy link

@OctavianCC OctavianCC commented Oct 20, 2017

Hi,

currently there is no public RML utilities available for SQL Server 2016 and newer (I can use SQLNexus only for SQL Server version 2014 or older). Can you public a new version of them where we can use also profiler/xperf traces for SQL Server 2016 or later?

Thanks,
Octavian

@suresh-kandoth

This comment has been minimized.

Copy link
Member

@suresh-kandoth suresh-kandoth commented Dec 6, 2017

Octavian, we have a preview build that can process 2016 and 2017 versions. If you want to try it out, please send me an email : suresh_dot_kandoth_at_microsoft_dot_com
We have plans to update the public downloads with the latest versions.
Thanks
Suresh

@DanielAdeniji

This comment has been minimized.

Copy link

@DanielAdeniji DanielAdeniji commented Jan 29, 2018

Suresh Kandoth or anyone else that is able to, please provide a link for RML utilities - v2016/v2017.

Daniel Adeniji

@johnmart82

This comment has been minimized.

Copy link

@johnmart82 johnmart82 commented Feb 15, 2018

Is there any update on when RML that supports 2016/2017 will be available publicly?

@JosephOBrienDBA

This comment has been minimized.

Copy link

@JosephOBrienDBA JosephOBrienDBA commented May 29, 2018

Why are we still waiting for a version of ReadTrace that can process Sql Server 2016?

@suresh-kandoth

This comment has been minimized.

Copy link
Member

@suresh-kandoth suresh-kandoth commented Jun 3, 2018

To get a version of ReadTrace that can process SQL Server 2016 and 2017 trace files or XEL files, follow these steps:

  1. Download the Database Experimentation Assistant (DEA) from https://www.microsoft.com/en-us/download/details.aspx?id=54090
  2. Install the DEA toolset. Default path used is "C:\Program Files (x86)\Microsoft Corporation\Database Experimentation Assistant"
  3. If you look in the folder "C:\Program Files (x86)\Microsoft Corporation\Database Experimentation Assistant\Dependencies\X64" you will notice the latest versions of ReadTrace.
  4. Make a backup copy of your existing ReadTrace and other related files from C:\Program Files\Microsoft Corporation\RMLUtils
  5. Copy the 4 files from "C:\Program Files (x86)\Microsoft Corporation\Database Experimentation Assistant\Dependencies\X64" to "C:\Program Files\Microsoft Corporation\RMLUtils" and overwrite the existing files.
  6. Now you should able to process the trace files of SQL Server 2016 and 2017 using the newer version of ReadTrace.

The team that owns the ReadTrace utilities has an action item to update/refresh the download bits for RML with these new binaries. There is no estimated date on when this will be made available.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
5 participants
You can’t perform that action at this time.