Skip to content

SQL Nexus version 7.24.02.18

Choose a tag to compare

View all tags
@PiJoCoder PiJoCoder released this 16 Feb 16:24
· 64 commits to master since this release
7.24.02.18
3185114

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

Note: Starting with this version 7.24.02.18, it's no longer required to install SQLSysClrTypes and ReportViewer Control. These come packaged with SQL Nexus

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.24.02.18_Signed.zip from Assets below. This is a zip file that contains Microsoft digitally-signed binaries
  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.24.02.18_Signed.zip file, using this command:

certutil -hashfile SQLNexus_7.24.02.18_Signed.zip SHA512

Compare to this:

5d54142e4bc8ca193ad51edb4641de199670719a2c645b662505d541162a9535bd1af94a87dfe2d62854219bfc5c14c74059c69549a93daf3b13873116f04d8f

List of fixes and enhancements:

  • Fixes issue with PowerBi Performance Report that does not display many of the report charts from an FCI instance - #241
  • Adds the option in the GUI to enable/disable minimizing of window when processing Permfon BLG files - #250
  • Add REDO_THREAD_PENDING_WORK to ignorable wait types in reports - #251
  • Add new XML rowsets to SQL Nexus for In-memory /plan cache - #246
    • tbl_proccache_summary
    • tbl_proccache_pollution
    • tbl_dm_db_xtp_index_stats
    • tbl_dm_db_xtp_hash_index_stats
    • tbl_dm_db_xtp_table_memory_stats
    • tbl_dm_db_xtp_memory_consumers
    • tbl_dm_db_xtp_object_stats
    • tbl_dm_xtp_system_memory_consumers
    • tbl_dm_xtp_system_memory_consumers_summary
    • tbl_dm_xtp_gc_stats
    • tbl_dm_xtp_gc_queue_stats
    • tbl_dm_db_xtp_transactions
    • tbl_dm_xtp_transaction_stats
  • If a report uses multiple tables it should not appear on SQL Perf Main report when not all tables are present - #232
  • Fixes Workingset Trimming Report not working - #247
  • Add a new Best Practice/Analysis Summary warning for Common Criteria Compliance being enabled - #243
  • Option to import traces using Local Server time. (Call ReadTrace.exe with -B)- #238
  • Some Importer options aren't "saved" despite "Save my options" being enabled - #254
  • Expose the report queries within each SQL Nexus report so users can customize their data mining - #239
  • Make SQL Nexus case-sensitivity aware for case-sensitive servers - #61
  • Server Name and version information fields exists on the header of some reports but it is always empty. - #263
  • New Rowset Editor application that helps with adding rowsets for import into SQL Nexus - #268
  • Create a rowset to import Environmental variables collection in a table tbl_environment_variables - #271
  • Add some wait types to ignorable list so they don't show up in bottleneck analysis report: CHECKPOINT_QUEUE, PARALLEL_REDO_WORKER_WAIT_WORK, QDS_ASYNC_QUEUE, PWAIT_EXTENSIBILITY_CLEANUP_TASK - #265
  • Remove the installation prerequisite on ReportViewer control ship with application. Also update version of Report Viewer Control (15.0.1586.0)- #140
  • Switch SQL Nexus to use Microsoft.Data.SqlClient - #270

Development Environment:

Visual Studio 2015/2017/2019/2022

Assets 3
Loading