Skip to content

SQL Nexus version 7.25.04.25

Latest
Latest

Choose a tag to compare

View all tags
@PiJoCoder PiJoCoder released this 01 May 15:58
· 37 commits to master since this release
7.25.04.25
8e0be13
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

Prerequisites to run SQL Nexus

  1. .NET framework 4.8 (runtime is sufficient). Windows 11 has version already.
  2. Download and install RML Utilities (RMLSetup_AMD64.msi)
  3. An instance of SQL Server (versions 2012 through 2022) to connect to and process data
  4. 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.
  2. Extract in a path location of your choice
  3. 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 #379
  • Add rowset for Dot Net versions and sys.servers by @PiJoCoder in #384
  • #387 - Removing 2 rowsets from the RowsetImporter by @asavioliMSFT in #388
  • Updates for #377 Non-Microsoft filter driver missing in the Filter drivers report and #380 expensive events by @hacitandogan in #381
  • Add elapsed_time_seconds column to tbl_open_transactions rowset by @asavioliMSFT in #390
  • Rowsets for SQL Agent jobs, CLR , Execution memory, installed programs by @PiJoCoder in #392
  • Some number related columns are being imported by Nexus as null (tbl_MissingIndexes & tbl_dm_db_stats_properties) by @hacitandogan in #393
  • Version bump by @PiJoCoder in #396

Full Changelog: 7.24.10.10...7.25.04.25

Contributors

PiJoCoder, hacitandogan, and asavioliMSFT
Assets 3
Loading