SQLAuthority News – Download RML Utilities for SQL Server

Note:   Download RML Utilities for SQL Server by Microsoft

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 2000, 2005 and 2008.

Download RML Utilities for SQL Server

Abstract courtesy : Microsoft

Reference: Pinal Dave (http://www.SQLAuthority.com)

, , ,
Previous Post
SQL SERVER – Delete Backup History – Cleanup Backup History
Next Post
SQLAuthority News – RML Utilities – Usage and Additional Help

Related Posts

2 Comments. Leave new

  • Hi Panel,

    I downloaded that tool to use testing before after Upgrade(2000 to 2008),

    Please define what are thhe columns I have to select for 2000.

    Note: RML help document has only 2005 and 2008 required cloumns for trace.

    Reply

Leave a Reply

Menu