I’m a huge fan of RML utilities for SQL DB Engine workload analysis. Its a fantastic tool fro being able to capture a trace and point a finger at offending users, applications, batches, queries and even see plans and resource usage.
You can download RML from this link
http://www.microsoft.com/en-us/download/details.aspx?id=4511
One issue is that the Report viewer hyperlinks don’t work out of the box on Windows 8.1. A Patch is needed for the SSRS 2012 Report viewer component which you can download here.
https://connect.microsoft.com/VisualStudio/Downloads/DownloadDetails.aspx?DownloadID=37409
The quality of RML utilities is one of the biggest reasons that our SQL consultants (including myself) are slow to adopt extended events in a mainstream fashion. While extended events can have great instrumentation they still lack the presentation layer and analytics that RML brings. Who knows, maybe we can convince CSS to write an extended events version of RML utilities – that would change the scene over night!
