RML Utilities for SQL Server (x86)

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


    File Name:


    Date Published:


    File Size:

    10.1 MB

    KB Articles: KB944837

      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 and SQL 2014.
  • Supported Operating System

    Windows 7, Windows 8, Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Windows Vista

      IMPORTANT: If you are running a 64 bit operating system you must download the X64 version of the tools. The x86 version of the tools will not run in the WOW on a 64 bit operating system.

    • The RML Utilities require the Microsoft Report Viewer 2008 Redistributable (SP1 or later). Use the link under Related Resources to download and install that package.
    • This Cumulative Update package is a rollup of all fixes made in the 9.04 version of the utilities. All prior versions of the RML Utilities must be uninstalled before running this package. This package includes: • SQL Azure – Connectivity and ReadTrace/Reporter database storage support • SQL Server 2012/2014 Client and Server Versions supported • SQL 2005 thru SQL 2012/2014 Engine TRC support • SQL Server 2012/2014 XEL ReadTrace support, including limited 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 (OStress and Replay do not support MARS connections) • Reduced memory footprint across all utilities • .NET 4.0 Framework • Performance enhancements (> 64 CPU support, processor group awareness, NUMA awareness) • Parallel worker pools used internally to boost performance and reduce system impact • Rollup of RML hotfixes • Logging enhancements and additions