SQLAuthority News – Download RML Utilities for SQL Server
November 12, 2008 by pinaldave
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
Posted in Best Practices, Database, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Performance, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology | 1 Comment
Leave a Reply
[...] 13, 2008 by pinaldave Yesterday I wrote about SQLAuthority News – Download RML Utilities for SQL Server. I received many emails where different developers requested how to find additional help regarding [...]