WORKAROUND
Regarding the OutOfMemory error -
When we generate large data at least more than 50 k queries then Issue is coming so we are providing work around on this issue. You can follow the below steps to avoid Out of memory issue
1. Go to the given path as " C:\Users(username)\AppData\Roaming\Quest Software\Quest SQL Optimizer for SQL Server\10.1.2"
Note: Kindly refer the current user/logged in user name folder.
2. Go to the "Find SQL Data" .
3. Backup the folder and remove the contents.
Suggestion:
While performing Find SQL operation then once how many SQLs in Plan Cache is detected, it will show a window to configure the collecting criteria, here you can configure how many SQL to collect. For example, you can only collect the SQL from a specific database.
STATUS
Waiting for fix in a future release of SQL Optimizer for SQL Server