microsoft/SqlNexus 7.25.04.25

SQL Nexus version 7.25.04.25

Repository: microsoft/SqlNexus

Tag: 7.25.04.25

Published: 2025-05-01T15:58:46Z

Prerelease: no

Release notes:

Prerequisites to run SQL Nexus

1. .NET framework 4.8 (runtime is sufficient). Windows 11 has version already. 1. Download and install RML Utilities (RMLSetup_AMD64.msi) 1. An instance of SQL Server (versions 2012 through 2022) to connect to and process data 1. Optional: PowerBI Desktop

Automate Prerequisites Installation

You can use the following PowerShell file (https://github.com/microsoft/SqlNexus/blob/master/Setup-Related/SetupSQLNexusPrereq.ps1) to install the three required and one optional prerequisites for SQL Nexus

How to Download and Use

1. Download the SQLNexus_7.25.04.25_Signed.zip from Assets below. This is a zip file that contains Microsoft digitally-signed binaries for SQL Nexus. 1. Extract in a path location of your choice 1. Go to the path and run sqlnexus.exe

Verify downloaded file:

You can verify the download by computing the hash of the SQLNexus_7.25.04.25_Signed.zip file, using this command:

certutil -hashfile SQLNexus_7.25.04.25_Signed.zip SHA512

Compare to this:

5eb6bc2720ccc63f9fab08d28616d0b246a89731f73d7f599eb1234d26c705225c7983ca980fb77f482a7a92f6dcc9283d8570d7ba8a2cd84c6b98dd15fb72cb

List of fixes and enhancements:

• Create a rowset for Installed programs captured by SQL LogScout
• Add rowsets for SQL Agent jobs information and some CLR DMVs
• Add new column elapsed time to tbl_open_transactions rowset
• Database Mail - Some DMVs are failing to be imported by Nexus
• Improve the Report Query Execution Memory (Memory Grants)
• Some float/decimal columns are being imported by Nexus as null (tbl_MissingIndexes & tbl_dm_db_stats_properties)
• Add a XML rowsets for .NET Fx /.NET core version and sys.servers captured in SQL LogScout
• Other waits report failing to load with data time out of range convesion error
• Best Practices & Analysis Summary Report - Incorrectly raising warning about Expensive Events on system_health session.
• Update Setup-Related/SetupSQLNexusPrereq.ps1 to point to the latest version of RML utilities (09.04.0103)
• Non-Microsoft filter drivers missing in the "Filter Drivers" report
• Remove tbl_sysinfo as it's not used and incorrectly populated

Development Environment:

Visual Studio 2015/2017/2019/2022

What's Changed

• Update prerequisites file to get the latest RML util version by @PiJoCoder in https://github.com/microsoft/SqlNexus/pull/379
• Add rowset for Dot Net versions and sys.servers by @PiJoCoder in https://github.com/microsoft/SqlNexus/pull/384
• #387 - Removing 2 rowsets from the RowsetImporter by @asavioliMSFT in https://github.com/microsoft/SqlNexus/pull/388
• Updates for #377 Non-Microsoft filter driver missing in the Filter drivers report and #380 expensive events by @hacitandogan in https://github.com/microsoft/SqlNexus/pull/381
• Add elapsed_time_seconds column to tbl_open_transactions rowset by @asavioliMSFT in https://github.com/microsoft/SqlNexus/pull/390
• Rowsets for SQL Agent jobs, CLR , Execution memory, installed programs by @PiJoCoder in https://github.com/microsoft/SqlNexus/pull/392
• Some number related columns are being imported by Nexus as null (tbl_MissingIndexes & tbl_dm_db_stats_properties) by @hacitandogan in https://github.com/microsoft/SqlNexus/pull/393
• Version bump by @PiJoCoder in https://github.com/microsoft/SqlNexus/pull/396

Full Changelog: https://github.com/microsoft/SqlNexus/compare/7.24.10.10...7.25.04.25