New in this Release
The following is a list of issues addressed and enhancements implemented in this release.
Fixed an issue that in Databases - SQL PI dashboard, Workload line bars may display as blank even when Workload has value.
Fixed an issue that the Workload chart in Global view has different unit (sessions/s) from the one (seconds/s) in Overview.
Fixed an issue that the CSV input file may be locked due to I/O has not been closed after executing CLI commands.
Fixed an issue that when trying to migrate DB agent with IC agent monitoring, it failed an error message.
Fixed an issue that the SSAS-Instance status display N/A on SSAS > Overview dashboard.
Fixed an issue that Foglight for SQL Server didn't display correct execution plan.
Fixed an issue that the PI Engine uses incorrect 1m table name when the OS is using Thai Year Format.
Fixed an issue that Active/Inactive Sessions data is missing intermittently in the SSAS Overview dashboard.
Fixed an issue that failed to enable PI with Azure Active Directory (AAD) Authentication.
Fixed an issue that only 24-hour period deadlocks data is visible in Databases.
Fixed the incorrect unit in description of alarm DBSS - Buffer Pages Free.
Fixed an issue when adding instances through Import from file in Advance mode, it neither prompts Missing credential nor auto-fills the DB credential to monitor agent after clicking monitor.
Fixed an issue that when generating a Dimension Table With Metric Selector new Report from a SQL PI Dashboard Report, it failed to keep Column selection.
Fixed an issue that the Metrics of service status are wrongly synchronized to master FMS.
Fixed the very large duration values in Long Running Package alarm.
Fixed the very large durations under Package Execution dashboard.
Fixed an issue that the Non-Preferred node alarms have been cleared without moving the SQL to the preferred node.
Fixed an issue when generating Index Fragmentation report, a numeric overflow error is created.
Fixed an issue when the setup agent in CLI mode has a lower-case instance name, it failed to add instance to data group.
Fixed an issue that DBSS_Replication_Agents collection could cause blocking on the monitored database.
Fixed an issue that the parameter [Collation] uses Database level rather than Server Property.
Fixed the DBSS_In_Memory_XTP collection failure.
Fixed the SQL Server UpSince metrics missing issue.
Fixed the incorrect size type (MB v.s. KB) for the SQL Server Error Logs files.
Fixed an issue that the Estimated data loss is always 0.
Fixed the incorrect setting for Number of rows to be retrieved from log file.
Management Server version 5.9.2, 5.9.3, 5.9.4, or 5.9.5
To upgrade Foglight for SQL Server:
Important: If you are upgrading to the current version of Foglight for SQL Server in a Federation architecture, the upgrade should be applied first to the Federated Children and then to the Federation Master. If the Federation Master is upgraded first, it will display incorrect information regarding the number of instances being monitored in the Status Summary section.
The Foglight for SQL Server 220.127.116.11 cartridge is available for download from here.
IMPORTANT: This 18.104.22.168 cartridge is not compatible with the SQL Server PI repository, please consult KB 313648 for more details.