Find Specific Information in Collectors
From the SQL Collector window, you can search for SQL statements in Collectors that have specific text in the SQL text, the query plan, and/or a certain SQL classification.
To open the Find Collectors window
Select Collector | Find Collector.
The Find Collector window has two tabs to specify what text to search for. If you select multiple items, the search is combined as an AND search so that it searches for SQL statements that include all the selected items. After you have selected the search criteria, click Find to search for the SQL statements which contains all search criteria.
Find Tab
Text to find
- Under the Find tab, specify the text to search for in the SQL text.
- SQL
- Specify the text to search for in the SQL text.
Options
- Case sensitive
- Specify whether to search for the text in exact case that you enter it.
- Whole word only
- Specify whether to search for words only.
Advanced Tab
Text to find
- Under the Advanced tab, specify the text to search for in the SQL Information Pane.
- Query plan
- Specify the text to search for in the query plan.
- Abstract plan
- Specify the text to search for in the abstract plan.
- Trace On Information
- Specify the text to search for in the dbcc trace on information.
- Information
- Specify the text to search for in the SQL classification Monitored SQL information.
Type
Check the SQL Classification type defined for the Collector.
Search Results
The search results are displayed at the bottom of the Find Collectors window. It displays the Collector name and the SQL name for the SQL statements which contain the search criteria.
Related Topics
Find SQL Statement
SQL Collector for Monitor Server Overview
SQL Collector Window
