SQL Optimization 'Optimize SQL by Plan Control' error: Access violation at address 21505426 in module 'QOptEngineLib.dll'. (4308490)

Chatee ahora con Soporte

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

SQL Optimization 'Optimize SQL by Plan Control' error: Access violation at address 21505426 in module 'QOptEngineLib.dll'.
Descripción

SQL Optimization 'Optimize SQL by Plan Control' error:
"Access violation at address 21505426 in module 'QOptEngineLib.dll'. Read of address 00000004"
Causa

Optimization was being done on a read-only database.
Resolución

Since it needs to deploy alternative plan to SQL Server during the optimizing plan process, try not to do this on read-only databases. It is also better that the login has sysadmin role. Also, because the Plan Control is to deploy plan guide to improve the performance, some limitations about Plan Guides should be aware of such as the query text should be exactly matched.

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Producto(s):: SQL Optimizer for SQL Server
10.0.1; Toad for SQL Server

Historial del artículo:: Creado el: 8/15/2017
Última actualización: 5/7/2023

Título