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

NOTE You can send an e-mail to [e-mail] and request the
latest build for RML Utilities with the ReadTrace and SQL Nexus log i le as
attachments.
SUMMARY
The SQL Nexus tool can enable you to reduce the time it takes to analyze collected diagnostic data
by aggregating and importing the data into a SQL Server database. The graphical reports shipped
with SQL Nexus help you in drawing pertinent hypotheses for the most common SQL Server
performance problems within a few minutes. The tool is widely used by SQL Server professionals to
diagnose SQL Server performance issues for their customer environments.
Identifying the right set of data to be collected is always the i rst step of the process, a task discussed
in Chapter 11. Once you have that data, analyzing it to draw the right set of conclusions to form
a spot-on hypothesis is critical. SQL Nexus is just the tool to aid you in creating your hypothesis!
SQL Nexus' value will become obvious when you have to sift through gigabytes of diagnostic data
within a short period of time. That is when you realize that having the diagnostic data in a database
table(s) with indexes built on them can be a time and life (or job) saver.