Development Environment:

Visual Studio 2015/2017/2019/2022

Prerequisites to run SQL Nexus

1. .NET framework 4.8 (runtime is sufficient). Windows 11 has version already.
2. Download and install SQLSysClrTypes
3. Download and install ReportViewer control (ReportViewer.msi)
4. Download and install RML Utilities (RMLSetup_AMD64.msi)
5. An instance of SQL Server (2012 or above) to connect to and process data
6. 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_v_7_22_11_11_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.22.03.23_Signed.zip file, using this command:

certutil -hashfile SQLNexus_v_7_22_11_11_Signed.zip SHA512

Compare to this:

109496d029cabdb4e352736a0354ad2ec39b56010ec3aa4028cea9a5451b9c1ea980001aa02b447b1962f82972a3b98079a913df397d4cd19e53bb825a9e80e2

List of fixes and enhancements:

• Added new rowsets to Textrowset file, so now more tables will be imported and can be queried (if data is captured)
  • tbl_SystemInformation
  • tbl_ActiveProcesses_OS
  • tbl_database_scoped_configurations
  • tbl_ActiveServices_OS
  • tbl_ActiveProcesses_with_ModulesLoaded
  • tbl_dm_os_sys_info
  • tbl_index_resumable_operations
  • tbl_dm_os_sys_info (was not importing before due to incorrect identifier)
  • tbl_availability_groups
  • tbl_availability_replicas
  • tbl_fltmc_filters
  • tbl_tempdb_space_usage_by_file
  • tbl_dm_db_file_space_usage_summary
  • tbl_dm_db_session_space_usage
  • tbl_dm_db_task_space_usage
  • tbl_open_transactions
  • tbl_tempdb_usage_by_object
  • tbl_tempdb_waits
  • tbl_dm_tran_aborted_transactions
  • tbl_dm_tran_persistent_version_store_stats
  • tbl_repl_sourceserver
  • tbl_repl_msdb_jobs
  • tbl_repl_msarticles
  • tbl_repl_mscached_peer_lsns
  • tbl_repl_msdistribution_agents
  • tbl_repl_msdistribution_history
  • tbl_repl_mslogreader_agents
  • tbl_repl_mslogreader_history
  • tbl_repl_msmerge_agents
  • tbl_repl_msmerge_history
  • tbl_repl_msmerge_identity_range_allocations
  • tbl_repl_msmerge_sessions
  • tbl_repl_msmerge_subscriptions
  • tbl_repl_mspublication_access
  • tbl_repl_mspublications
  • tbl_repl_mspublicationthresholds
  • tbl_repl_mspublisher_databases
  • tbl_repl_msqreader_agents
  • tbl_repl_msrepl_backup_lsns
  • tbl_repl_msrepl_commands_oldest
  • tbl_repl_msrepl_commands_newest
  • tbl_repl_msrepl_errors
  • tbl_repl_msrepl_identity_range
  • tbl_repl_msrepl_originators
  • tbl_repl_msrepl_transactions_oldest
  • tbl_repl_msrepl_transactions_newest
  • tbl_repl_msrepl_version
  • tbl_repl_msreplication_monitordata
  • tbl_repl_mssnapshot_agents
  • tbl_repl_mssnapshot_history
  • tbl_repl_mssubscriber_info
  • tbl_repl_mssubscriber_schedule
  • tbl_repl_mssubscriptions
  • tbl_repl_mssync_states
  • tbl_repl_mstracer_history
  • tbl_repl_mstracer_tokens
  • tbl_repl_msRedirected_Publishers
  • tbl_repl_msreplservers
  • tbl_repl_sysservers
  • tbl_repl_msrepl_agent_jobs
  • tbl_windows_hotfixes_installed
• Added post-import clean-up for tbl_ActiveProcesses_OS and tbl_SystemInformation
• Added a new test file in Tests/Post-Import-Test.sql to help indetify which tables were imported
• Removed the word Idle from the title in CPU report #88
• Added a Linux perfmon converter, which converts Linux OS counter files to .BLG files (does not import them) - #160
• Fixing #166 and some issues with tbl_availability_replicas where replica_id and group_id were not being imported successfully
• Create, Clean-up/deduplicate AG-related XML rowsets in the RowsetImportEngine\TextRowset.xml #157
• Fixed exception for missing table tbl_PERF_STATS_SCRIPT_RUNTIMES #55
• Cleaned up old names in reports #162
• Added usp_Expensive_TraceEvts_Used and usp_Expensive_XEvts_Used #78 rules to check for expensive Xevents and Trace events
• Upgrade the target .NET Framework to supported version 4.8 #173
• Add lookup table for filter drivers FLTMC so we can display manufacturer name for drivers #183
• Switched to using Perfmon counters for bottleneck analysis CPU graph #193
• Create new SQL Nexus reports for Always On Datasets #172
• Create a RDL report that shows Replication topology and other repl output #189
• Add a new RDL report to display filter drivers info #200
• Test SQL Nexus on SQL Server 2022 and on Windows 2022 #181
• Issue with SQLNexus_PostProcessing.sql where the StartTime_Local and EndTime_local not being created #133
• Add a InputFile column to all resultsets in the SQL PerfSnapshot SQL script to distinguish startup vs. shutdown collection #138