Foglight® for Azure SQL Database 5.9.5.20
Developed and tested for Foglight Management Server 5.9.2, 5.9.3, 5.9.4, 5.9.5, and 5.9.7
Release Notes Revision 1
April 2020
Revision 1:
Foglight for Azure SQL Database 5.9.5.20 Release Notes Revision 1 is a re-release of the Foglight for Azure SQL Database 5.9.5.20 Release Notes with the following change:
Welcome to Foglight for Azure SQL Database
Getting started with Foglight for Azure SQL Database
Foglight® for Azure SQL Database allows DBAs to quickly and efficiently identify performance deviations, determine their root cause, perform comprehensive analyses, and resolve performance bottlenecks. The product provides web-enabled dashboards for centralized visibility, management and health checks for the Azure SQL Database deployed in your environment, as well as proactive alerting and alarm workflows for tracking your responses to critical performance anomalies.
Foglight for Azure SQL Database is an n-tier application, which leverages a web-based user interface to ensure having complete visibility into the Azure SQL Database infrastructure wherever an Internet connection is available.
These Release Notes cover the known issues, workarounds, and other important information about 5.9.5.20 release of Foglight for Azure SQL Database. Review all sections before starting installation.
Foglight for Azure SQL DB monitors the Azure SQL Database activity by connecting to and querying the database. Version 5.9.5.20 of Foglight for Azure SQL Database contains the following main features and functions:
Added Heatmap-Style Global View.
The following is a list of issues addressed and enhancements implemented in this release.
Defect ID |
Resolved Issue |
AZFOG-28 |
Fixed an issue that due to script errors, failed to change the RMI port configuration. |
AZFOG-25 |
Fixed an issue that Azure cartridge rule SQL_AZURE-EmailNotification_Rule_General and Oracle cartridge rule DBO-EmailNotification_Rule_General have the same ID. |
AZFOG-16 |
Fixed an issue that the blocked process count does not match on blocking dashboard. |
AZFOG-8 |
Fixed an issue that FileNotFoundException occurs in Azure SQL DB agent log. |
AZFOG-4 |
Fixed an issue that the severity icon and unit of Query Store Utilization are not showing up for a fresh monitored instance. |
FOGDG-1323 |
Fixed an issue that the potential email notification string combination is incorrect. |
The following is a list of issues known to exist at the time of this release.
Defect ID |
Known Issue |
AZFOG-29 |
When accessing the Database dashboard, no entry to the Upgrade wizard
can be found after new version cartridge has been installed. |
SSFOG-1569 |
User Level Access and Manage Alarm Blackouts are not supported for 5.9.5.10 Azure SQL DB, and they are not UI limitation/notes. |
SSFOG-1629 |
Azure cannot change RMI setting in Administration. |
GVFOG-207 |
An error log showed in FMS log for loading heatmap component in FMS version before 5.9.3. |
n/a |
Cross platform report is not supported for Azure SQL DB. |
n/a |
Agent does not support MFA (Multi-Factor_Authentication) connections to Azure databases. |
The following is a list of third party issues known to exist at the time of this release.
Defect ID |
Known Issue |
FOGDG-650 |
The Foglight Agent Manager (FglAM) failed to restart when upgrading DB Cartridge, which is due to "Could not obtain a deployment lock" error. Workaround: Perform the procedure described in the Knowledge Article 266110. |
FOGDG-1372 |
Cannot use AD account to monitor Azure SQL DB when the FglAM deploy
in Azure VM. |
n/a |
The Windows System Center Endpoint Protection (SCEP) tool and Anti-Virus
Protection tools installed on Windows® may negatively impact CPU and
system performance of machines running Foglight, Foglight Agent
Manager, and the SQL PI repository.
|
n/a |
Anti-virus software may negatively impact the CPU and system performance of machines running Foglight. To reduce resource consumption, it is highly recommended to exclude the relevant directory, processes, and executables from being scanned by the anti-virus software. For detailed information, refer to the "Configuring anti-virus exclusion settings" in Installing Foglight on Windows with an Embedded PostgreSQL Database. |
n/a |
The Foglight Time Bar Chart click event does not work with Chrome version 40.x.x.x and 39.x.x.x. https://code.google.com/p/chromium/issues/detail?id=428308 |
The following Foglight product versions and platforms are compatible with this release.
Product Name |
Product Version |
Platform |
Foglight Management Server |
5.9.2 5.9.3 5.9.4 5.9.5 5.9.7 |
All platforms supported by these versions of the Foglight Management Server |
Foglight Agent Manager Note: The monitoring agents
available in this version of Foglight for Azure SQL Database support the
Agent Manager HA failover mode, except for the Agent Manager
monitoring SQL PI agents. For more information about this mode, see
the Agent Manager Guide.
|
5.9.2 5.9.3 5.9.4 5.9.5 5.9.7 |
All platforms supported by these versions of the Foglight Agent Manager |
Note: Foglight for Azure SQL Database 5.9.5.20 is compatible with Foglight 5.9.7, however, it cannot run on Foglight 5.9.7 with FIPS-compliant mode enabled.
Before installing Foglight for Azure SQL Database, ensure that your system meets the hardware and software requirements detailed in Foglight System Requirements and Platform Support Guide. Customers running large deployments (more than 20 agents) should consult the Foglight for Databases Deployment Guide.
For information on the required privileges, refer to the Foglight for Databases Deployment Guide.
Support for Microsoft® Internet Explorer® 8, 9, and 10 has been discontinued in this Foglight release.
Microsoft ended the support for these browsers on January 12, 2016. For more information, visit https://support.microsoft.com/en-us/lifecycle?p1=13418.
This section provides a list of references which address the most commonly faced issues relating to remote connectivity, allowing for easy troubleshooting using the vendor's information knowledgebase:
Foglight includes a licensing capability that restricts access to those features that are defined in the license. Any Management Server installation requires a license that grants access to server-specific parts of the browser interface and the features associated with them. Foglight cartridges are also license-protected. While some cartridges are covered by the base Foglight license (such as Foglight Agent Manager cartridges and the Foglight for Infrastructure), others may require an additional license.
Foglight for Azure SQL Database is covered by the base Foglight license that allows cartridges to be installed.
To activate a trial or a purchased commercial license:
The Foglight for SQL Azure 5.9.5.20 release package contains the following:
For installation pre-requisites, permissions, information necessary to determine your environment’s hardware requirements, and for installation instructions, see the Foglight for Databases Deployment Guide.
Additional information is available from the following:
This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.
This release is Unicode-enabled and supports any character set. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.
This release has the following known capabilities or limitations: The server will be enabled for Global Operation, but not localized to any particular locale.
We are on a quest to make your information technology work harder for you. That is why we build community-driven software solutions that help you spend less time on IT administration and more time on business innovation. We help you modernize your data center, get you to the cloud quicker and provide the expertise, security and accessibility you need to grow your data-driven business. Combined with Quest’s invitation to the global community to be a part of its innovation, and our firm commitment to ensuring customer satisfaction, we continue to deliver solutions that have a real impact on our customers today and leave a legacy we are proud of. We are challenging the status quo by transforming into a new software company. And as your partner, we work tirelessly to make sure your information technology is designed for you and by you. This is our mission, and we are in this together. Welcome to a new Quest. You are invited to Join the Innovation™.
Our logo reflects our story: innovation, community and support. An important part of this story begins with the letter Q. It is a perfect circle, representing our commitment to technological precision and strength. The space in the Q itself symbolizes our need to add the missing piece — you — to the community, to the new Quest.
For sales or other inquiries, visit https://www.quest.com/company/contact-us.aspx/.
Technical support is available to Quest customers with a valid maintenance contract and customers who have trial versions. You can access the Quest Support Portal at https://support.quest.com.
The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. The Support Portal enables you to:
Quest, the Quest logo, Foglight, and Join the Innovation are trademarks and registered trademarks of Quest Software Inc. in the U.S.A. and other countries. For a complete list of Quest Software trademarks, please visit our website at www.quest.com/legal. Red Hat, JBoss, the JBoss logo, and Red Hat Enterprise Linux are registered trademarks of Red Hat, Inc. in the U.S. and other countries. CentOS is a trademark of Red Hat, Inc. in the U.S. and other countries. Fedora and the Infinity design logo are trademarks of Red Hat, Inc. Microsoft, .NET, Active Directory, Internet Explorer, Hyper-V, Office 365, SharePoint, Silverlight,SQL Server, Visual Basic, Windows, Windows Vista and Windows Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. AIX, IBM, PowerPC, PowerVM, and WebSphere are trademarks of International Business Machines Corporation, registered in many jurisdictions worldwide. Java, Oracle, Oracle Solaris, PeopleSoft, Siebel, Sun, WebLogic, and ZFS are trademarks or registered trademarks of Oracle and/or its affiliates in the United States and other countries. SPARC is a registered trademark of SPARC International, Inc. in the United States and other countries. Products bearing the SPARC trademarks are based on an architecture developed by Oracle Corporation. OpenLDAP is a registered trademark of the OpenLDAP Foundation. HP is a registered trademark that belongs to HewlettPackard Development Company, L.P. Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both. MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries. Novell and eDirectory are registered trademarks of Novell, Inc., in the United States and other countries. VMware, ESX, ESXi, vSphere, vCenter, vMotion, and vCloud Director are registered trademarks or trademarks of VMware, Inc. in the United States and/or other jurisdictions. Sybase is a registered trademark of Sybase, Inc. The X Window System and UNIX are registered trademarks of The Open Group. Mozilla and Firefox are registered trademarks of the Mozilla Foundation. IOS is a registered trademark or trademark of Cisco Systems, Inc. and/or its affiliates in the United States and certain other countries. Apple, iPad, iPhone, Mac OS, Safari, Swift, and Xcode are trademarks of Apple Inc., registered in the U.S. and other countries. Ubuntu is a registered trademark of Canonical Ltd. Symantec and Veritas are trademarks or registered trademarks of Symantec Corporation or its affiliates in the U.S. and other countries. OpenSUSE, SUSE, and YAST are registered trademarks of SUSE LCC in the United States and other countries. Citrix, AppFlow, NetScaler, XenApp, and XenDesktop are trademarks of Citrix Systems, Inc. and/or one or more of its subsidiaries, and may be registered in the United States Patent and Trademark Office and in other countries. PostgreSQL is a registered trademark of the PostgreSQL Global Development Group. MariaDB is a trademark or registered trademark of MariaDB Corporation Ab in the European Union and United States of America and/or other countries. Intel, Itanium, Pentium, and Xeon are trademarks of Intel Corporation in the U.S. and/or other countries. Debian is a registered trademark of Software in the Public Interest, Inc. OpenStack is a trademark of the OpenStack Foundation. Amazon Web Services, the "Powered by Amazon Web Services" logo, and "Amazon RDS" are trademarks of Amazon.com, Inc. or its affiliates in the United States and/or other countries. Infobright, Infobright Community Edition and Infobright Enterprise Edition are trademarks of Infobright Inc. POLYCOM®, RealPresence® Collaboration Server, and RMX® are registered trademarks of Polycom, Inc. All other marks and names mentioned herein may be trademarks of their respective companies.