SQL Server Tools
Here is a collection of SQL Server tools I’ve run across. These are all free tools, some from Microsoft and some from the SQL Server community.
SQL Cop: Runs checks on a database to find potential issues, like tables missing primary keys, use of deprecated data types, etc.
Microsoft Assessment and Planning (MAP) Toolkit for SQL Server: Lists all SQL Server instances in an environment,including version, edition as well as information on the host(OS, # of cores, etc).
SQL Query Stress: Developed by Adam Machanic, this is a tool to load test queries. It can create up to 200 threads to create a test load.
SQL Server Diagnostics: An add-in for SSMS (2016 or later). It can analyze memory dumps and give recommendations for issues. It also recommends Cumulative Updates for fixes for specific features being used in a specific instance.
SQL Server Migration Assistant: Tools to move data into SQL Server from Access, Oracle, MySQL and other databases.
Database Experimentation Assistant: Testing program to identify potential issues when upgrading to a newer edition of SQL Server.
Tiger Team Github: Various tools from the SQL Server engineering team. The SQL Performance dashboard reports in particular are very useful.
DiskSpd: Tool for testing storage. Takes the place of the SQLIO utility.