Utilities: RML Utilities from PSS

The SQL Server PSS group announces the release of RML Utilities.

 From the blog post: 

The Microsoft SQL Server support team uses several internally-written utilities to make it easier to work on a typical customer support case. These utilities may also be useful to database developers and system administrators who work with Microsoft SQL Server 2000 and Microsoft SQL Server 2005.  The utilities are collectively called the RML Utilities for SQL Server.

 

With the RML Utilities you can answer questions such as the following:

 

·         Which application, database or login is consuming 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 as compared to a previous set of data.

 

You can also test how the system will behave with some change (different service pack or hot fix 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.

Very cool!

o<:{> Andy

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, Azure Data Factory, SSIS guy, and farmer. I was cloud before cloud was cool. :{>

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.