Bringing It All Together with SQL Nexus - SQL Server 2012 Internals and Troubleshooting - page 340

If you do use the Export option, Access Control Lists (ACLs) are applied to the reports to prevent
unauthorized access. The user exporting the report will be the only one who has full-access on the
exported report. The user of Reporter has ultimate responsibility for propagation of the data.
Comparative Analysis Report Generated by Reporter.exe
To view the preceding reports, you can also use the Reporter executable, which is available under
the C:\Program Files\Microsoft Corporation\RMLUtils folder, which can be launched by
double-clicking the Reporter.exe available in the aforementioned folder. One of the really use-
ful things that the Reporter can do for you is comparative analysis. If you have collected two sets
of diagnostic data from the same SQL Server instance at different times, then you can import the
SQL Trace data into two separate databases and perform an automated comparative analysis using
Reporter. Once the analysis is done, it displays
a comparison chart like the one shown in Figure 12-18. The detail table at the bottom of the
Comparison Overview report shows a comparison of the aggregated summary of
the queries found in both databases. The RML Utilities Help i le, available after installation, has
copious documentation on the reports and their usage.
FIGURE 12-18
CUSTOMIZING SQL NEXUS
This section explains how you can add customizations to SQL Nexus and RML Utilities to help
you with your analysis or redo tasks that you repeatedly perform during your data analysis. The
following sections will help you understand the following: