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

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

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

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

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.
Lösung

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 übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Artikelhistorie:: Erstellt am: 11/22/2010
Letzte Aktualisierung am: 5/7/2023

Titel