Most awaited tool for SQL Server DBA and experts (heard of ReadTrace!). Till sometime back these tools were only accessible to Microsoft SQL Server support team.
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.
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 plans changes for a batch during the time when 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?
Most important these tools can help you on:
Testing 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.
Simulating application testing where using the real application is impractical or impossible.
For example, it may be difficult to generate the same user load in the test environment as you see in production.
This release of the utilities supersedes the previous version, as described in KB articleThis release supports SQL Server 2005 and SQL Server 2000 trace file formats and should be used any time you have SQL Server 2005 in your environment. This release contains important bug fixes, new features and performance enhancements over the prior release.
For complete details refer to Quick Start section on the help file of tool (Start | Programs | RML Utilities for SQL Server and selecting RML Help.xps).
Enjoy working with RML Utilities and other tools like SQLDiag, PSSDiag, SQLNexus !