RML Utilities for SQL Server - Update Oct 2024

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 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019, 2022.

Supported Operating Systems

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

Windows Server 2016 or newer Windows 10 and newer

The RML Utilities can be installed using the setup RMLSetup.msi file. They require additional dependencies to be installed. 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:

• Bug fix that allows you to run RML Utilities on a system that doesn't have the SQL Native Client driver installed (e.g. SQL Server 2022 only). Instead RML Utilities will use the Microsoft ODBC or OLE DB Driver for SQL Server
• Accessibility fixes or enhancements for Reporter.exe (contrast themes, contrast rations, narrator fixes, etc)