Performance Analysis for SQL Server - Knowledge Base

Filter Your Results
Search All Products

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
Product Enhancements (Ideas)
Contact Us
Technical Support
View All

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 669
How to uninstall a corrupted Performance Analysis Agent installation for Oracle or SQL Server? (44712)

The user tried to uninstall Performance Analysis for Oracle and Performance Analysis for SQL Server. The user got a message saying: "The agent installation specified to be uninstalled is corrupted. Please use the brute Uninstall ...

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle
Last Updated On: 4/17/2018
(0 Ratings) 11304 views
Checking for blocked ports from a remote computer when TELNET is not available (238273)

Blocked ports often contribute to product connection issues. Typically, Support requests to use TELNET or even run a “portable” version of PuTTY to test the connection. Increasingly customers are reluctant to install Telnet on their servers for security reasons. ...

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle...
Last Updated On: 2/22/2018
(0 Ratings) 410 views
The installer file for the Performance Analysis for SQL Server is missing. (230773)

The installer file for the Performance Analysis is missing. The Performance Analysis is set to End-Of-Life. To view the notification, please click here . Please upgrade to Performance Investigator.

Product(s): Performance Analysis for SQL Server
Last Updated On: 1/11/2018
(0 Ratings) 3 views
Meltdown (CVE-2017-5715) and Spectre (CVE-2017-5753 & CVE-2017-5754) CPU Vulnerability (237415)

Meltdown (CVE-2017-5715) and Spectre (CVE-2017-5753 & CVE-2017-5754) exploit critical vulnerabilities in modern processors. These hardware bugs allow programs to steal data which is currently processed on the computer. ...

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle...
Last Updated On: 1/8/2018
(0 Ratings) 22 views
Combination of SQL Server 32bit instance and Windows 64bit OS prevents Performance Analysis (PA) (50881)

Performance Analysis for SQL Server (PASS) is not showing the basic SQL counters that are normally shown because the 64bit counters prevent PASS from collecting PDH Counters. PA fails to read PDH Counters, it will show ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 12/26/2017
(0 Ratings) 1599 views
Is it possible for PA to monitor Mountpoints in Windows instead of the drives? (135111)

In a clustered drive, when DB files and logs are created in different mountpoints but on the same drive, Performance Analysis (PA) provides advisories for the Drive utilization and not for individual mount points. In Windows, PA ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 12/26/2017
(0 Ratings) 1253 views
"Reached into unexpected line in code" when attempting to install in a cluster environment (50669)

ERROR: An internal issue has occurred. Please retry the last operation to continue the installation process. If this attempt also fails, please contact Quest Support. Please send to Quest support the content of the following directory: /path< PA_Logs.xxx.zip>. ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 12/26/2017
(0 Ratings) 1541 views
CPU usage not collected (77915)

If I narrow down "Workload" to just CPU or memory under History, only one TSQL Batch is listed. Having disk subsystem (SAN) upgrade issues that drove IO wait to intolerable levels. When the TSQL Batches dimension is selected ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 12/26/2017
(0 Ratings) 1509 views
What are the Performance Analysis Scenarios? (49949)

What are the Performance Analysis Scenarios? and what is the correlation with the Repsository? PA uses three scenarios: StealthCollect scenario (SC), which is responsible to pass data from MW to the Repository database. ...

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1681 views
Sizing Documents for Performance Analysis for SQL Server (PASS) and Oracle (PAO) 7.0.4 and later (206900)

Sizing Document information for PASS and PAO 7.0.4 and later. In order to aquire the correct hardware for the MiddleWare machine, it is a prerequisite to use this document correctly. There is a specific sizing document for each database application. SQL Server Sizing Doc. ...

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1963 views
Problem changing password in Verify Account panel. (120496)

We recently updated the SA account password across our SQL Servers. Opening the PA client, and attempting to connect gives errors. Running account verification shows a bad password, however as you can see from the screenshot ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 12/26/2017
(0 Ratings) 1226 views
How to run Performance Analysis for SQL Server with limited privileges? (47717)

How to run Performance Analysis for SQL Server with limited privileges? Refer to the attached PDF file with the instructions on which privileges need to be granted to the Performance Analysis user. Note the QuestPAPrivileges ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 12/26/2017
(0 Ratings) 1570 views
Is there an option to show more than 25 number for each dimension in History? (64654)

Is there an option to show more than 25 number for each dimension in History? You can adjust the Performance Analysis (PA) Display Options to show more than 25 for each dimension in the History. Please take a look at the attached screenshot.

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1502 views
How to use Performance Analysis for SQL Server to troubleshoot blocking issues (74801)

How do we use Performance Analysis for SQL Server to troubleshoot blocking issues. Performance Analysis for SQL Server has a Historical Lock Analysis tool the can help troubleshoot blocking issues (see pdf file attached for more information).

Product(s): Performance Analysis for SQL Server
Last Updated On: 12/26/2017
(0 Ratings) 1476 views
Verify Accounts would hang at the repository section (47418)

When performing accounts verification, it would hang when it reaches the repository section. Restart the QAM Launcher Service on both the middleware and Monitored Host, and re-try to Verify Accounts. Go to Start | Settings ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 12/26/2017
(0 Ratings) 1372 views
Database list not being displayed when Memory Resource is selected (51943)

Database list not being displayed when Memory Resource is selected. No Memory waits in the given time period, thus, there are databases being displayed. If there are only waits for CPU Usage, Network Wait, and Log Wait ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 12/26/2017
(0 Ratings) 1383 views
The purpose for Performance Analysis for SQL Server 70451 Patch (119683)

This section describes the issues addressed by this patch. This patch should only be applied if your system is affected by the following defect/condition: The REDO_THREAD_PENDING_WORK wait event is categorized as OTHER instead of IDLE. ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 12/26/2017
(0 Ratings) 1253 views
Does Performance Analysis for SQL SERVER support SQL server 2005 Express? (42332)

Does Performance Analysis for SQL SERVER support SQL server 2005 Express? No, SQL SERVER 2005 Express is not supported. Below is a snip of the versions we support: Please see attached is the release notes for platforms ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 12/26/2017
(0 Ratings) 1567 views
What files are required when raising a case to support for Performance Analysis please? (90749)

Having an issue with Performance Analysis and want to raise a case to the support tem, but wnat to know what files will make it easier and quicker for them to look into the issue? The attached word document gives details as ...

Product(s): QCO Performance Analysis, Performance Analysis for SQL Server...
Last Updated On: 12/22/2017
(0 Ratings) 2226 views
Is there a way to create the Perfomance Analysis for SQL Server Repository Manually? (102550)

When installing Performance Analysis for SQL Server, I get as far as the Repository install and it fails. Is there a way to try to do the install manually? This could be a connection issue between the monitored host machine, Middleware ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 12/22/2017
(0 Ratings) 1478 views
An Internal issue has occurred during the Agent Installation (55783)

During the Agent installer, the attached error message appears stating "An Internal issue has occurred". The current Launcher.log appears to be running on port 3566 and this log shows that port 3566 is not a open port and thus Launcher fails to listen. ...

Product(s): BridgeWare, Performance Analysis for SQL Server
Last Updated On: 12/20/2017
(0 Ratings) 4230 views
Can data be migrated from PA to PI? (229832)

Can historical data be migrated from the Performance Analysis products to Foglight SQL PI for Oracle or SQL Server? Historical data cannot be migrated from Performance Analysis (PA) to Foglight SQL PI.

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle...
Last Updated On: 11/23/2017
(0 Ratings) 979 views
Is there any documentation about the Performance Analysis Repository schema? (36157)

Is there any documentation available regarding the Performance Analysis (PA) Repository schema? This information is needed in order to facilitate the creation of custom reports or extract PA data. Please refer to attached documents. NOTE: ...

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle
Last Updated On: 11/20/2017
(0 Ratings) 3701 views
Does SQL Server Cartridge 5.7.x support Performance Analysis? (148208)

Does the SQL Server Cartridge 5.7.1.1 and higher support Performance Analysis for SQL Server (PASS) integration? In Foglight for SQL Server Cartridge 5.7.5.1 and above, Performance Analysis (PA) integration is no longer ...

Product(s): Performance Analysis for SQL Server, Foglight
Last Updated On: 10/24/2017
(0 Ratings) 3039 views
Which Performance Analysis version is compatible with DB cartridge 5.5.8.5? (82066)

After upgrading to DB cartridge version 5.5.8.5 the following error regarding Performance Analysis appears: "The currently installed StealthCollect version, 7.0.240.0, does not support full cartridge functionality. Please upgrade StealthCollect to the most updated version. ". ...

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle...
Last Updated On: 10/2/2017
(0 Ratings) 1788 views