DB24 LogoDB24 Docs_

    Version 2026.1

    Last updated: March 4, 2026•
    performance

    DB24 Release Notes - Version 2026.1

    Release Date: Februari 2, 2026

    The DB24 2026.1 release is the Performance PowerTake — a major step forward in how DB24 measures, analyzes, and scales SQL Server performance.
    This release introduces a new generation of performance metrics alongside significant runtime, datastore, and portal performance improvements.

    The result is faster insights, clearer diagnostics, and a smoother experience across large and complex environments.

    Key updates:

    • New performance analytics suite with CPU, IO, waits, index efficiency, and consolidation insights
    • High‑resolution historical workload collection for accurate trend and capacity analysis
    • Major Portal and Datastore performance optimizations
    • Numerous stability and correctness fixes across Runtime, Datastore, and Portal

    🌟 Spotlight: Performance PowerTake

    Performance PowerTake is about turning raw workload data into clear, actionable insight.
    DB24 now captures performance metrics and transforms it into reports that answer real‑world DBA questions — not just snapshots, but behavior over time.

    This release helps you:

    • Understand when and why performance pressure occurs
    • Identify the true resource bottlenecks
    • Evaluate consolidation scenarios using real historical load

    ➡️ New Features

    New Performance Metrics

    DB24 introduces a new set of performance‑focused reports built on minute‑level workload collection and hourly aggregation.

    CPU Usage Report

    • Minute‑level CPU collection, aggregated by hour
    • Distinguishes SQL Server load from other host processes
    • Identifies CPU pressure patterns over time

    Database IO Metrics Report

    • Hourly aggregation of database file IO activity
    • Highlights read vs write pressure
    • Identifies databases responsible for IO load

    Waits Metrics Report

    • Hourly aggregation of wait statistics
    • Separates signal waits from resource waits
    • Clarifies whether waits are CPU, storage, locking, or network related

    Index Efficiency Report

    • Analyzes non‑clustered index usage and effectiveness

    Consolidation Report

    • Uses real historical workload data
    • Simulates how instances would behave when consolidated
    • Answers questions like:

      “Based on the last 7 days, what happens if we consolidate these instances onto a 16‑core server?”

    Portal – Collect and Display Heaviest Queries

    • Displays CPU‑intensive, long‑running, and write‑heavy queries
    • Provides direct insight into workload drivers

    Portal – Improved Application Performance

    • Optimized portal queries and rendering
    • New datastore indexes for faster page loads
    • Noticeably improved responsiveness in large environments

    Portal – Show Category AiQ Score per Instance

    • AiQ datagrid now shows category‑level scores
    • Improves visibility into strengths and weaknesses per instance

    Portal – Set Environment Color

    • Assign custom colors per environment
    • Color is applied to the top header
    • Makes environment context immediately visible

    Portal – Add Recovery Model and ReadOnly to Backup Status

    • Backup Status report now includes:
      • Recovery Model
      • ReadOnly state
    • Improves interpretation of backup behavior and warnings

    Portal – Bad Booleans Highlighting

    • Datagrids visually highlight risky boolean values
    • Example: red checkbox when xp_cmdshell is enabled
    • Makes unsafe configurations easier to spot

    Datastore – New VolumeInfo Object

    • Stores latest state of volumes hosting SQL Server files
    • Includes filesystem details and aggregated data/log sizes
    • Improves accuracy of space‑related insights and alerts

    Datastore – Public Exposed Views

    • Version‑controlled views in the api schema
    • Stable, supported interface for external integrations
    • Enables safe access to curated DB24 data

    Datastore – Collect Index Fragmentation Information

    • Captures index fragmentation before maintenance
    • Supports historical trend analysis

    Datastore – Optimize Facts Collection

    • Improved collection logic and indexing
    • Faster and more efficient data ingestion
    • Reduced overall datastore load

    Datastore – Backup & Alert Refinements

    • Snapshot backups included in Backup Status
    • Backup Size Deviations exclude Snapshot and CopyOnly backups
    • Backup Path Deviation exclusions supported
    • TargetObject added to Security Audit alert exclusions

    Notifications – Aggregated Alerts

    • Backup warnings are aggregated into a single row
    • Reduces noise in large environments
    • Improves readability and actionability

    🐞 Bug Fixes

    Runtime – Availability Group Space Metrics

    • Fixed missing space metrics for AG primary databases
    • Reads from readable secondaries when possible

    Runtime – Long Index Name Handling

    • Fixed failures when index names reached 128 characters
    • Index collection is now fully reliable

    Runtime – Housekeeping Schedule Warnings

    • Removed misleading agent warnings during schedule updates
    • Prevents false error log noise

    Runtime – SQL Server Utilization Calculations

    • Fixed incorrect CPU unit conversions
    • Added normalized load per day per core
    • Improves cross‑instance comparability

    Runtime – Log Growth Safeguards

    • Caps rows in log.Runtime and log.Datastore
    • Prevents uncontrolled log growth

    Datastore – Disk Space Warnings

    • Disk space warnings now use VolumeInfo
    • Ensures briefs and alerts reflect current state

    Datastore – AiQ Scoring Accuracy

    • Negative AiQ values excluded from critical parameters
    • Prevents misleading gamification scores

    Datastore – SQL Builds & Patches Classification

    • Extended Support versions now classified as MS Supported
    • Improves accuracy of support status reporting

    🧭 Summary

    DB24 2026.1 is a performance‑driven release focused on depth, accuracy, and scale.
    With high‑resolution workload analytics, smarter reporting, and major performance optimizations across the platform, Performance PowerTake gives you the insight needed to plan, tune, and consolidate with confidence.

    This release strengthens DB24’s position as a decision‑grade performance platform for modern SQL Server environments.