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 (2012 or above) to connect to and process data
4. Optional: PowerBI Desktop

Note: Starting this version 7.27.02.18, it's no longer required to install SQLSysClrTypes and ReportViewer Control. These come packaged with 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