Add SQL Collectors from the SQL Collector (Add Jobs Wizard)
View Add Jobs Wizard--Add SQL Collector
You may want to scan the Collectors from the SQL Collector for Monitor Server module to identify the SELECT, INSERT, UDPATE and DELETE SQL statements with their query plan and trace on (if available). This gives you a better understanding of which SQL statement is causing the performance problem within the database server.
To add Collectors
-
Select the SQL Collector page.
-
Select a Collector and click
.
-
Use the Use Database and Set User drop down lists to select the database and user that corresponds with the SQL that you are scanning.
Note: The parameter settings for Problematic, Complex, and Simple SQL statements may differ between SQL Collector for Monitor Server and SQL Scanner modules.