Statistica is now part of TIBCO. Beginning June 5th, Statistica customers will need to use TIBCO Support's customer portal, to receive assistance with Statistica.

Performance Analysis for SQL Server - Knowledge Base

Filter Your Results
Search All Products

Self Service Tools
Knowledge Base
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
Product Enhancements (Ideas)
Contact Support
Contact Support

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 712
A SQL statement looks like it is in MySQL format as it references the IFNULL function (230057)

A SQL statement that is captured by Performance Analysis for SQL Server appears to be in MySQL format as it references the IFNULL function. "IFNULL" is a MySQL function not a SQL Server function. This is a bug in the "View SQL" feature. WORKAROUND. None. STATUS. ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 6/2/2017
(0 Ratings) 13 views
Scheduled reports by domain account not running (229864)

Scheduled reports in Performance Analysis (PA) under a domain account does not generate the report. The task runs completely but no files are generated. When running PA as the domain account, it is able to generate a report via the PA GUI. ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 5/29/2017
(0 Ratings) 15 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: 5/26/2017
(0 Ratings) 76 views
Microsoft SQL Server 2014 (SP2) 12.0.500 support for Performance Analysis for SQL Server. (223252)

Is Microsoft SQL Server 2014 (SP2) 12.0.5000 supported with Performance Analysis for SQL Server (PASS)? Microsoft SQL Server 2014 (SP2) 12.0.5000 has been tested and is not supported with Performance Analysis for SQL Server 7.0.506. ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 5/11/2017
(0 Ratings) 390 views
Does PA for SQLServer (PASS) supports new SQLServer versions and/or patches? (212722)

Does PA for SQLServer (PASS) supports new SQLServer versions and/or patches? PA has reached End of Life and no new versions and patches are being developed. Hence new versions or patches of SQLServer are not certified to be supported by PASS. ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 5/11/2017
(0 Ratings) 1035 views
Installing Performance Analysis for SQL Server against SQL Server version Microsoft SQL Server 2 (91311)

When trying to install Performance Analysis for SQL Server against SQL Server version Microsoft SQL Server 2000 - 8.00.818 (Intel X86), the install fails. Can you explain this please? Performance Analysis for SQL Server supports ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 5/9/2017
(0 Ratings) 1788 views
Is there a limit on the maximum number of monitored instances in PASS repository database? (124400)

Is there a limitation on the maximum number of monitored instances by Performance Analysis for SQL Server (PASS) repository database? There is no limitation on the number of Instances monitored by PASS repository database. ...

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle...
Last Updated On: 4/10/2017
(0 Ratings) 1806 views
Using more than 50 monitored instances in a PA repository (133214)

Please review the screenprint and advise is there any limit we are reaching? what's the impact? Exceeding the recommended number of monitored instances in a PASS repository database could cause it to get to the point where ...

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle...
Last Updated On: 4/10/2017
(0 Ratings) 2644 views
Performance Analysis for SQL Server GUI client 7.0.4.4 (agentless) (188043)

This patch should only be applied if your system is affected by the following defects/conditions: Agentless PASS GUI Client supporting short-term and long-term data view, without running Collector. The following is a list of issues resolved in this patch. ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 4/6/2017
(0 Ratings) 1166 views
Does SQL Server Cartridge 5.7.x support Performance Analysis? (148208)

Does the SQL Server Cartridge 5.7 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 an option and ...

Product(s): Performance Analysis for SQL Server, Foglight
Last Updated On: 4/3/2017
(0 Ratings) 2321 views
The database operation failed: "No connection could be made because the target machine actively refused it" (176577)

Error installing on a cluster on a separate domain: No connection could be made because the target machine actively refused it. Followed KB 88204 to be able to connect via fully qualified domain name (FQDN). Things to check: 1. Login to your middleware. ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 3/27/2017
(0 Ratings) 1738 views
How to migrate or move the middleware and Quest repository database to a new server? (99057)

A new server is purchased and we would like to migrate / move the current middleware server agent and Quest Performance repository database to the new server. The Quest Performance repository database currently resides ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 2/27/2017
(1 Ratings) 4556 views
Advisories on SQL PI (151158)

SQL Performance Investigator (SQL PI) does not seem to have the Advisories feature similar to the Performance Analysis for SQL Server (PA). Are there plans to include this feature in SQL PI? WORKAROUND: None. STATUS: Issue fixed in version 5.7.5.35. ...

Product(s): Performance Analysis for SQL Server, Foglight for Virtualization...
Last Updated On: 2/13/2017
(0 Ratings) 2906 views
Unable to reinstall Performance Analysis GUI client: "Nothing has been selected for installation" (132499)

When trying to uninstall Performance Analysis (PA) client GUI, the install wizard is stating that: Nothing has been selected for installation. Following KB Article 32493 does not seem to help and there is no Quest Installer shortcut ...

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle...
Last Updated On: 1/31/2017
(0 Ratings) 4600 views
PA client getting stuck on install during "Preparing Configuration files". (147944)

When installing the PASS client on a workstation with other Quest products including Toad, the client is getting stuck on "Preparing Configuration files". The PASS 7.0.4.4 client could be installed however successfully on another ...

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle...
Last Updated On: 1/31/2017
(0 Ratings) 3119 views
Scheduling a report of the Advisories details to be printed off (98885)

Can an advisories report be scheduled to be e-mailed and printed off? The Advisories report is not part of the regular report system in PA, so it is not possible to schedule Advisories reports.

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle...
Last Updated On: 1/24/2017
(0 Ratings) 2118 views
More information on how to use Performance Analysis for SQL Server (103795)

How can we find more information on how to use Foglight Performance Analysis for SQL Server? Is there a User Guide for Foglight Performance Analysis? The Online Help within the product itself (the ? icon), is context sensitive ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 1/24/2017
(0 Ratings) 1424 views
"Connection was reset by the remote host" trying to connect to the monitored instance with Performance Analysis GUI (88035)

Trying to connect to the monitored instance with Performance Analysis GUI produces this error... Connection was reset by the remote host. All but a small fraction of the config files were accidentally deleted from the following location on the monitored server... ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 1/24/2017
(0 Ratings) 1970 views
Can an upgrade be done from Performance Analysis for SQL Server 6.5 to the latest version of 7.0? (88123)

Can an upgrade be done from Performance Analysis for SQL Server 6.5 to the latest version of 7.0? Yes, as per the details within the release notes below an upgrade from 6.5 to the latest version of Performance Analysis which is 7.0.310: ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 1/24/2017
(0 Ratings) 1577 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: 1/24/2017
(0 Ratings) 3037 views
Does Performance Analysis for SQL Server support SQL Server 2008 R2? (73932)

Does Performance Analysis for SQL Server support SQL Server 2008 R2? SQL Server 2008 R2 monitoring was supported beginning with the 7.0.310 version of Performance Analysis for SQL Server. The latest version of PASS is available for download from here: ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 1/24/2017
(0 Ratings) 1655 views
Is the SQL Server collation SQL_1xCompat_CP850_CI_AS supported by Performance Analysis for SQL Server? (73166)

Is the SQL Server collation SQL_1xCompat_CP850_CI_AS supported by Performance Analysis for SQL Server? The collation SQL_1xCompat_CP850_CI_AS that as it is as Western European it should work. However, we cannot ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 1/24/2017
(0 Ratings) 2518 views
Collector keeps dying trying to connect to Performance Analysis Agent (50359)

Error occurred while trying to connect to Performance Analysis Agent Collector keeps dying /agent/log/activity.log (on Monitored Host) file shows multiple MW that sample the same collector, like: StealthCollect@6.0@ quest_sc_collector@Collector1-Instance1 (2211972) killed ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 1/24/2017
(0 Ratings) 2105 views
Background activity is too high due to un-idle wait events (7.0.459 collector patch) (124459)

Background activity is too high due to un-idle wait events. Wait events need to be adjusted to support SQL Server 11.0.3339.0 This issue has been fixed in the 7.0.459 collector patch. Read this First. This patch may receive additional testing. ...

Product(s): Performance Analysis for SQL Server
Last Updated On: 1/24/2017
(0 Ratings) 1561 views
Is there an area within Performance analysis that shows blocking locks? (118781)

Is there an area within Performance analysis that shows blocking locks? Look under Tools | Historical Lock Analysis. Also Under History or Real time, if you change the Resource type to Lock, a tab below will appear called "Blocking Locks" where you can see them.

Product(s): Performance Analysis for SQL Server
Last Updated On: 1/24/2017
(0 Ratings) 1195 views