SQL Optimizer for SQL Server crashes with huge number of results. (4279217)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

SQL Optimizer for SQL Server crashes with huge number of results.
Description

Application crashes when a report with a big number of results is being opened.
Resolution

WORKAROUND:
Here is a workaround to avoid the crash because of “out of memory”.
How to find data folder:
1. Launch the SQL Optimizer for SQL Server
2. Open the Options window and Click the “Show Details”
3. You will see the data folder of Find SQL
Workaround
1. Find the data folder of Find SQL module (It is same as I mentioned above).
2. Try to remove all stuff in the data folder.
3. Launch SQL Optimizer for SQL Server and open Find SQL module
4. Add new task to collect SQLs from Plan Cache
5. Once how many SQLs in Plan Cache is detected, it will show a window to configure the collecting,
SOLUTION:
Waiting for a fix in a future version of SQL Optimizer for SQL Server.
Defect ID

QSOSS-1323

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title