Foglight Release Notes for SQL Server
This release of Foglight for SQL Database brings a range of updates and enhancements aimed at improving performance, reliability, and usability.
This section covers the following key areas:
What’s New
| Features | GA Month |
|---|---|
| The SPI Global View now supports SQL Server PI agents. | August 2026 |
| Unified PI REST API to add support for Snowflake | May 2026 |
| Added ability to collect deadlocks in a dedicated extended event session for better efficiency. For more information refer to Deadlock Collection Methods. | December 2025 |
| Enhance the backup alarms for availability group databases. Alarm now checking backup across all availability group replicas monitored by Foglight. | December 2025 |
| Enhanced Quick View and Real-time view for managed instance | December 2025 |
| Added an alarm for memory utilization for managed instance | December 2025 |
| Enhanced support for Azure SQL Managed instance - new resource utilization alarms and an updated overview displaying managed instance resource usage. | September 2025 |
| Enhanced support for Availability Groups - new alarms to track RPO and RTO based on threshold as well as new charts | September 2025 |
| Introduce Query Explorer - Introduce an easy and quick way to find queries and tune them by their text. Just copy your query from any tool and quickly get all query insights in one view. Also support analysis of top queries by their resource consumption. For more information, refer to Viewing Query Explorer. | July 2025 |
| Collecting deadlocks via extended events for AWS RDS | July 2025 |
| Support MFA connection using “Microsoft Entra” for Azure DB/MI. | February 2025 |
Resolved Issues
| Issue ID | Description | Time Fixed |
|---|---|---|
| FOG-12702 | Deadlock collection dedicated session not created for AWS RDS instances | October 2026 |
| FOG-11774 | Graphs occasionally appear to be polygons | August 2026 |
| FOG-14361 | DBSS Cluster Failover Alarm Fires for Servers Not Part of a Failover Cluster | July 2026 |
| FOG-14268 | User level access dashboard doesn’t show any instances if any BI instances are monitored | July 2026 |
| FOG-13966 | Dedicated XE session not created for on-prem SQL Server 15.0.2000.5 (script-version mapping missing) | June 2026 |
| FOG-13770 | java.lang.NoSuchFieldException: sys_paths when using MSSQL Windows Custom Auth (NTLMv2) on Java 17 | June 2026 |
| FOG-13502 | Backup Location SQL Query Returns Invalid Path for Malformed Device Names | June 2026 |
| FOG-13512 | DataDirect JDBC vulnerability | June 2026 |
| FOG-13305 | DBSSRMIDatabaseIndexList fails on large databases due to numeric overflow in index size/row calculations | June 2026 |
| FOG-13149 | SQL Server backup alarms are wrongfully fired when old backup exist on a secondary replica | March 2026 |
| FOG-12720 | Advisories/graphs not loading for certain events like lock waits | March 2026 |
| FOG-12525 | No blocking data when selecting a range of more than 30 days | March 2026 |
| FOG-12455 | Missing scrollbar in top FglAMs panel in the SQL PI Administration page | March 2026 |
| FOG-12449 | DBSS_Jobs_Failed alarm doesn’t trigger on the first time | March 2026 |
| HFIX-606 | No alarm for 1st job failure | January 2026 |
| FOG-11780 | Rule Template for “DBSS - Buffer Pages Free” is Enabled Despite Registry Value Disabling Alarm | December 2025 |
| FOG-3466 | Top Disk Space Usage Report includes RDS instances | December 2025 |
| FOG-5887 | Legacy LOB Type Incompatibility with _SC and _UTF8 Collations in Blocking_List and DBSS_Top1000_dm_Exec_Query_Stats_Entries collections | September 2025 |
| FOG-11952 | DBSS Long Running Session Threshold not getting updated via Alarm Template | September 2025 |
| FOG-11225 | DBSS_HADR_Availability_Group_Databases_11_0_0_0 collection failing in SQL server 2012 | September 2025 |
| FOG-12012 | Graphs occasionally appear to be polygons | September 2025 |
| FOG-11468 | Cross Availability Report has Inconsistent UP/Start time values | July 2025 |
| FOG-11049 | Fix collection when SQL Server is running on a Linux machine | July 2025 |
| FOG-10962 | Incorrect sort by UpSince on SQL PI Global view dashboard | July 2025 |
| FOG-11283 | DBSS_JobsFailed-AutoClear get reset | July 2025 |
| FOG-11150 | SQL server show incorrect host name in Databases page | July 2025 |
| FOG-10232 | DBSS_Error_Log_Data collection failing when monitored instances have DBs with different collation | March 2025 |
| FOG-10558 | DBSS_Agent_Job_List collection return incorrect job current_status | March 2025 |
| FOG-10034 | fix the “IO Dimension” PI’s collection failed - table snot exist | February 2025 |
| FOG-4335 | Fix threshold setting for DBSS Long Running Job alarm | February 2025 |
| FOG-9904 | Align current wait mapping to new versions wait events | February 2025 |
| FOG-5463 | Fix blocking view to show recent blocking events even on large timeframes | February 2025 |
| FOG-10121 | Support proxy for monitoring with PI | February 2025 |
| FOG-4335 | DBSS Long Running Job: Rule would only work with Warning threshold | January 2025 |
| FOG-3795 | Create IC agent with FQDN host name | January 2025 |
| FOG-9893 | Changing credentials for DB agents doesn’t update credentials for PI | December 2024 |
| FOG-9787 | Use FQDN for Physical hostname | December 2024 |
| FOG-9760 | SSRS agent doesn’t display data | November 2024 |
| FOG-9684 | Add support for blocking in MARS (Multiple active results sets) sessions | November 2024 |
| FOG-9140 | Blocking collections not returning sql_text when Multiple Active Result Sets (MARS) is enabled and blocking session not running active request | November 2024 |
| FOG-9139 | Blocking collections not returning sql_text when Multiple Active Result Sets (MARS) is enabled and blocking session not running active request | November 2024 |
