Collecting Data For SQL Nexus

• Step by Step tasks has detailed info on how to collect data.
• For SQL Nexus, just choose version, platform and leave everything else as default. SQL Nexus will be able to analyze the data collected. SQL Nexus just need you to point to the output folder. For the curious this page has more information about output files.
• Alternatively, you can choose a detailed trace template. The screenshot below let you choose either GeneralPerformance10.xml or DetailedPerformance10.xml. If you choose _DetailedPerformance10.xml for tracing, more trace events will be captured but it can add load to your system in terms of IO requirement.