You can search for specific SQL statement executions across one or more databases using the statement's SQL identifier SQL ID.

Enter the SQL ID in the text entry field and hit Enter to display the SQL Search Results dialog.

Click Show to view the SQL statement in its entirety or Copy if you want to copy and paste the statement to a document for further analysis.

The SQL Search returns a list of databases where the SQL has been found over a specified time period. By default, seven days is used for the search window. Optionally, you can select up to 12 months for a broader view of SQL statement execution.

SQL Detail

To view detailed information on how the SQL has been used for a specific database, select a database from the list and click View SQL for Selected Database. The SQL Detail page for that statement displays. In addition to a summary of general usage information and performance statistics, you'll be able to view performance metrics, execution plans, as well as being able to compare plans.