Trace Id is missing

Copilot is your AI companion

Always by your side, ready to support you whenever and wherever you need it.
Download the Copilot app
A picture of a dog with a pop up bubble saying Talk to Copilot and asking What celeb does my dog look like?

RML Utilities for SQL Server - Update Dec 2022

Tools to help database administrators manage the performance of Microsoft SQL Server.

Important! Selecting a language below will dynamically change the complete page content to that language.

Download

  • Version:

    09.04.0102

    Date Published:

    1/4/2023

    File Name:

    RMLSetup.msi

    File Size:

    4.7 MB

    Do you know which databases or applications are using the most resources on your server? How will a service pack upgrade, configuration change or application change affect your production SQL Server? The RML Utilities for SQL Server provide you a set of tools and processes to answer these questions and much more.

    The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing. For example, you can quickly see:
    • Which application, database or login is using the most resources, and which queries are responsible for that
    • Whether there were any plan changes for a batch during the time when the trace was captured and how each of those plans performed
    • What queries are running slower in today's data compared to a previous set of data
    You can also test how the system will behave with some change (different service pack or hotfix build, changing a stored procedure or function, modifying or adding indexes, and so forth) by using the provided tools to replay the trace files against another instance of SQL Server. If you capture trace during this replay you can use the tools to directly compare to the original baseline capture.

    Supports SQL Server versions 2005 and 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019, 2022.

  • Supported Operating Systems

    Windows Server 2016, Windows Server 2019, Windows Server 2022, Windows 10, Windows 11

    Windows Server 2016 or newer Windows 10 and newer

  • The RML Utilities require additional dependencies to be install. See the instructions available at https://docs.microsoft.com/en-us/troubleshoot/sql/tools/replay-markup-language-utility

  • This update package is a rollup of all fixes made in the 9.00 version of the utilities. All prior versions of the RML Utilities must be uninstalled before running this package.

    This package includes:
    • Azure SQL – Connectivity and ReadTrace/Reporter database storage support
    • SQL Server 2012/2022 Client and Server Versions supported
    • SQL Server 2005 through 2022 Engine TRC support
    • SQL Server 2008 through 2022 XEL ReadTrace support, including XEL to TRC conversion
    • Improved compressed file handling (types and performance – See Expander documentation for complete details)
    • Includes ReadTrace, OStress and Reporter support for MARS connections
    • Reduced memory footprint across all utilities
    • Changed target to .NET 4.x Framework
    • Performance enhancements (> 64 CPU support, processor group awareness, NUMA awareness)
    • Parallel worker pools used internally to boost performance and reduce system impact
    • Logging enhancements and additions
    • SHA256 signed binaries and package (Aug 2021)
    • Bug fixes for detected missing column in ReadTrace.exe and strong name validation failure of Reporter.exe (Dec 2022)

Follow Microsoft

Back To Top