"Find SQL" funcionality takes a lot of time to return results (4334455)

It is needed to go through all the trace to collect each SQL statement so, the larger the file size is, the longer the time it take.
Then for each SQL statement collected, Find SQL will retrieve the execution plan.

WORKAROUND

Specifying a collecting criteria to reduce the total number of SQL collected might help.
This way we will retrieve the execution plan only for the desired SQL statement (anyway the trace file still has to go through completely).

To specify the criteria,

1. Click "Show Collect Criteria" hyperlink at the lower left corner in the "Add SQL Trace Search" dialog.

2. Click the plus sign to add a new condition

   For example And

           Application Name Equals Gestion

Enhancement request number ST-118914 has been submitted to Development for consideration in a future release of SQL Optimizer for SQL Server