Category
Versão do produto
Tópico
Subtópico
Error log entries do not match due to special characters, brackets (4378238)
Customers report having no success when trying to match, or ignore an error log entry which includes certain special characters: ... Reason: Password did not match that for the login provided. ... [CLIENT: <local machine>]
New Alarm Actions or changes to the existing ones are not saved after upgrading to Spotlight version 15.0 (4378025)
New Alarm Actions or changes to the existing ones are not saved after upgrading to Spotlight version 15.0. ... User created a new Alarm Action rule and clicks Ok to close the Alarm Action window.
When trying to optimize an index from a trace we are getting a lot of errors about missing columns/events (4332930)
What columns/events do we need to collect when running the trace? ... SQL Optimizer is complaining about some of the events like SP:StmtCompleted and SQL:StmtCompleted being missing and the optimize index cannot be run.
Clarification on Execution Statistics (4366230)
- Compile Elapsed Time ... - Compile CPU Time Execution Elapsed Time, Execution CPU Time, Compile Elapsed Time, Compile CPU Time ... - These four statistics are obtained by setting STATISTICS TIME ON when execution the SQL statement.
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host (4374996)
When trying to connect SQL Optimizer installed on a Windows Server 2019 to a SQL Server 2016 instance installed on Windows Server 2012 R2, you might get this error: ... “A connection was successfully established with the server, but then an error occurred during the login process.
Is there an msi version of the installation? (4234945)
On the Product Download page, the installation file is an exe. ... But some companies do not allow downloads for exe files. ... Is there an msi version that can be downloaded instead? ... For some products an msi version is available for download.
Error - Default Schema not available (4344779)
The customer run a process in SQL Optimizer with a user forming a part of an Active Directory group that has a SQL login with DB owner permissions for the database. ... “This job had an error during the process of scanning SQL: Default Schema not available.”
Cannot optimize query that uses variables of type table. (4367301)
A script was entered in Toad Editor and user has tried to optimize using SQL Optimizer. ... The query includes a join with a table type variable. ... Optimizer shows an error when user attempting to rewrite the query.<br><br>"Invalid SQL statement.<br>Only one SELECT/INSERT/UPDATE/DELETE/MERGE statement is allowed." <p>1.
Is there any way to customize the amount of time in minutes/hours the Scan SQL process will run? (4244559)
Is there any way to customize the amount of time in minutes/hours the Scan SQL process will run? ... There currently is no way to customize this.
Questions about SQL Scan and Optimizer regarding impact to PROD and what is saved where. (4249046)
This article covers the following questions about the SQL Scan and SQL Optimizer features. ... What is the impact in PROD databases when running? ... Where are the results stored? ... How many SQL sessions do the processes generate?
Getting error "Is not a valid integer value" when trying to optimize index from plan cache (4334933)
During the index optimizer process, the application raises the error that 4444,285010 Is not a valid integer value. ... The steps to reproduce the issue are the following: ... Open the "Control Panel" and Change the Format settings as "Spanish".
How to use Windows Authentication with a different user (4284098)
When we create a connection, an authentication type, when we choose windows authentication, its automatically fetch the logged in user without the option to change it. ... Can we use Windows authentication but have the option to use a domain user different from logged one?
SQL Optimizer connections linked from Foglight (4278563)
When we tune a code in Foglight and save the file, it opens SQL Optimizer and asks for connection to link to the code. ... Can we have one general connection that linked to all DB instances rather than having a different connection for each server (knowing that credential is same for all DB instances) Foglight and SQL Optimizer do not share connections.
When trying to optimize Index it errors out with "Unable to retrieve table id". (4232047)
When trying to optimize Index it errors out with "Unable to retrieve table id". ... None ... STATUS: ... Waiting for fix in a future version of SQL Optimizer for SQL Server.
Getting message that SQL Optimizer is not Installed when trying to launch. (4320575)
When trying to launch Optimizer from within Spotlight, a message pops up noting that SQL Optimizer for SQL Server is not installed. ... But it is installed on the same server as the Diagnostic Server.
Profile trace files, reducing bandwidth between servers in different locations (4275297)
When using SQL Optimizer with profile trace files and where the SQL servers are located, there is a large bandwidth between the office and the data center. ... How the bandwidth be reduced? ... How does this impact our production SQL server while running SQL Optimizer against it?
Connection times out due to not being able to use Named Pipes (4241499)
There is not an option, when connecting, to be able to use Named Pipes. ... In Toad, this option is available and there is no problem connecting. ... However, when conencting in SQL Optimizer, due to not being able to use Named Pipes, the connection keeps timing out.
User privileges (4278636)
What permissions does a user need to get recommendations for an optimization? <div>Find SQL:</div><div> VIEW SERVER STATE privilege: View the plan cache.</div><div></div><div>Manage Plan Guide:</div><div> ALTER privilege: Change some objects in the database.</div><div> EXECUTE privilege: Execute SQL.</div><div> SHOWPLAN privilege: Get the plan of the SQL.</div><div> REFERENCES privilege: Refer the database object normally.</div><div> ALTER privilege: Change some objects in the database.</div><div> ALTER SERVER STATE privilege: Validate the plan guide.</div><div></div><div>Optimize Indexes:</div><div> Server role of sysadmin and Database role of db_owner or db_ddladmin: Create an index.</div><div> CREATE TABLE on tempdb privilege: Create a temporary table.</div><div> SHOWPLAN privilege: Get the plan of the SQL.</div><div> SELECT on tempdb privilege: Query the temporary tables.</div><div> VIEW SERVER STATE privilege: View the plan cache.</div><div></div><div>Optimize SQL: </div><div> CREATE TABLE on tempdb privilege: Create a temporary table.</div><div> SHOWPLAN privilege: Get the plan of the SQL.</div><div> REFERENCES privilege: Refer the database object normally.</div><div> SELECT on tempdb privilege: Query the temporary tables.</div><div> EXECUTE privilege: Execute SQL.</div><div> Server role of sysadmin and Database role of db_owner or db_ddladmin: Get schema information.</div><div></div><div>Optimize SQL (Plan Control Mode):</div><div> ALTER privilege: Change some objects in the database.</div><div></div><div>Optimize SQL (Rewrite Mode):</div><div> Server role of sysadmin and Database role of db_owner or db_ddladmin: Create an index.</div><div></div><div>Scan SQL:</div><div> CREATE TABLE on tempdb privilege: Create a temporary table.</div><div> SELECT on tempdb privilege: Query the temporary tables.</div><div> SHOWPLAN privilege: Get the plan of the SQL.</div><div></div>
What's new in SQL Optimizer for SQL Server 10.1.1? (4241265)
This article contains some new features released with version 10.1.1. ... </div><div></div><ul><li>Improved performance when identifying invalid SQL. ... This release includes an enhancement to the SQL parsing process which significantly reduces the time required to identify certain invalid SQL statements.
Out of memory error while trying to generate report within Quest SQL Optimier for SQL Server</ (4327732)
Getting Out of memory error while trying to generate report within Quest SQL Optimier for SQL Server. ... 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.
Error during tune / optimize of query: "The necessary SQL Tuning files are not available..." (4285050)
Please install or reinstall SQL Tuning application ... SQL Optimizer for SQL Server is not installed. ... Quest SQL Optimizer for SQL Server is a separate application that must be installed.
Error during execution or optimization of queries using synonyms: "Invalid SQL statement." (4222968)
The following error occurs during execution or optimization of queries using synonyms: ... Table does not exist. ... Invalid object name .. ... Possible causes of this error are: ... - You are not pointing to the user and the database where the objects referenced by the SQL are located.
Error: Font ‘Courier New’ does not support style ‘Regular’ (4260674)
When user tries to use "Tune SQL" from within Performance Analysis (possibly just launching standalone would produce the same error as well), there is an error that states: Font ‘Courier New’ does not support style ‘Regular’.
Getting error when trying to optimize Indexes from a profiler (4330449)
SQL Optimizer crashes when trying to optimize indexes for some trace files. ... It starts to analyze the trace and then crashes with a Windows trash report. ... WORKAROUND ... Save the trace as trace table : After collecting the trace, go to Save | Save As | Trace Table
Product Key does not work on SQL Optimizer for SQL Server 7.0 (4260686)
SQL Optimizer 7.0.0 requires a new product key to activate the product. ... The Quest SQL Optimizer for SQL Server 6.x key is no longer supported. ... To request a new license key, please visit the following link:
Associação de novos produtos
- Ferramentas de autoatendimento
- Base de conhecimento
- Notificações e alertas
- Suporte a produtos
- Downloads de software
- Documentação técnica
- Fóruns de usuário
- Tutorial em vídeo
- Feed RSS
- Fale conosco
- Suporte técnico
- Visualizar tudo