Out of memory error while trying to generate report within Quest SQL Optimier for SQL Server</ (4327732)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Out of memory error while trying to generate report within Quest SQL Optimier for SQL Server
Description

Getting Out of memory error while trying to generate report within Quest SQL Optimier for SQL Server.
Cause

The Report component we deployed with our SQL Optimizer is not intelligent enough to handle reports with huge Execution Plans, it will not load the images on the fly.
Resolution

WORKAROUND
There is a quick workaround to turn off the "Scenario List" option in the report tab of SQL Optimize which should enable the report to run:
1. Create a new empty session in SQL Optimizer
2. Turn to Report Tab
3. Unchecked the Scenario List checkbox in Report Option as per attached screen shot.
4. Reopen the saved session file, the Out of Memory Exception should be gone, however Quest SQL Optimizer will not show all scenarios it will only show the Original and the Best.

STATUS
A fix for this issue has been targeted for a future release under ST77940

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title