Voltar
-
Título
Out of memory error while trying to generate report within Quest SQL Optimier for SQL Server -
Descrição
Getting Out of memory error while trying to generate report within Quest SQL Optimier for SQL Server.
-
Causa
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.
-
Resolução
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.STATUSA fix for this issue has been targeted for a future release under ST77940