The Analysis Wizard allows you to fine tune the type of analysis you want to perform on the target server. Note that analysis of the collected data may take several additional minutes and does not begin until the collection process is complete.
You can access the Analysis Wizard by clicking Analyze Server.
To use the Analysis Wizard to analyze a SQL Server instance:
On the Select SQL instance tab, select the SQL Server instance you want to analyze, if the instance does not appear in the list, verify that the instance is registered. Select between Collect query-related data using Extended Events (SQL 2012+) or Collect query-related data using SQL Trace (if applies), and then click Next.
The Extended Events options is disabled when analyzing SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2, and Amazon RDS SQL Server. The SQL Trace option is selected by default. |
Once your analysis is complete, you can review your results by:
| | | | | | | |