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.
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. |
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.
Icon made by mangsaabguru from www.flaticon.com