DBA MultiTool
October 6, 2024 ยท View on GitHub
The DBA MultiTool is a suite of scripts for the long haul:
optimizing storage, on-the-fly documentation, general administrative needs,
and more. Each script relies solely on T-SQL to ensure it is secure,
requires no third-party software, and can be installed in seconds.
Scripts
To install/update all the scripts, use install_dba-multitool.sql.
Looking for ways to automate the scripts? Try Install-DbaMultiTool from dbatools :rocket:,
or the Ansible collection lowlydba.sqlserver.
For detailed instructions and documentation, see dba-multitool.org
| Name | Description |
|---|---|
| sp_doc | Always have current documentation by generating it on the fly in markdown. |
| sp_estindex | Estimate a new index's size and statistics without having to create it. |
| sp_help_revlogin | Stored procedures that will help generate necessary scripts to transfer logins and their passwords. |
| sp_helpme | A drop-in modern alternative to sp_help. |
| sp_sizeoptimiser | Recommends space saving measures for data footprints, with special checks for SQL Server Express. |
Compatibility
Only support for versions that are still in mainstream support is guaranteed.
| Version | Tested |
|---|---|
| Azure SQL | :heavy_check_mark: |
| AWS RDS SQL Server * | :question: |
| SQL Server 2022 | :heavy_check_mark: |
| SQL Server 2019 | :heavy_check_mark: |
| SQL Server 2014-2017 | :shrug: |
| <= SQL Server 2012 | :x: |
* AWS RDS SQL Server is not tested, but should work in theory. YMMV.
Contributing
- Want to help :construction_worker:? Check out the contributing doc
- Missing a feature? Found a :bug:? Open an issue to get some :heart:
- Something else? Say hi in the SQL Server Community Slack #multitool channel
Icon made by mangsaabguru from www.flaticon.com