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 ๐,
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 | โ๏ธ |
AWS RDS SQL Server * | โ |
SQL Server 2022 | โ๏ธ |
SQL Server 2019 | โ๏ธ |
SQL Server 2017 | โ๏ธ |
SQL Server 2014-2016 | ๐คท |
<= SQL Server 2012 | โ |
* AWS RDS SQL Server is not tested, but should work in theory. YMMV.
- Want to help ๐ท? Check out the contributing doc
- Missing a feature? Found a ๐? Open an issue to get some โค๏ธ
- Something else? Say hi in the SQL Server Community Slack #multitool channel
Icon made by mangsaabguru from www.flaticon.com