20 free utilities and 89 scripts for monitoring and managing databases

You sit - the base grows, you go - the base grows, you sleep, eat or do many more things, but the base grows and grows. Someone very intelligent said that the only thing that is constantly in our life is change. The main thing is to react to them correctly. Any abnormal situation with the database is due to such changes. Unfortunately, it is not always possible to invest in an industrial monitoring system embroidered with gold and studded with 60 carat gemstones. And it makes resort to free or shareware solutions. In the article, I collected 20 free utilities from IDERA (and not only) that can help to close some issues with monitoring and managing MS SQL, MySQL and Oracle. Go!



# 1 SQL Check
The utility allows you to monitor the performance of SQL Server. No agent installation is required on the database server and injection of special objects directly into the database itself.


# 2 SQL Fragmentation Analyzer
The utility helps to find fragmented tables and warns when to defragment.
')


# 3 SQL XEvent Profiler
View sessions and executable SQL expressions. From additional buns - grouping, sorting and exporting events.



# 4 SQL Heat Map
A visual representation of the use of disk space in the context of all the tables in the database. It will help to manage capacity and forecast the resources that may be needed in the future. Quickly identify tables and indexes that require the allocation of additional disk space.



# 5 SQL Page Viewer
Convenient viewing and management of objects and events database.



# 6 SQL Update Statistics
Determine outdated statistics for tables and indexes, view and edit statistics options.



# 7 SQL Statistics Aggregator
Aggregation of IO statistics for identification of problem tables, correlation of disk activity with execution plans.



# 8 SQL Hekaton Memory Check
Monitoring the effect of memory utilization of specific database tables.



# 9 SQL Instance Check
Data collection and database inventory, checking the relevance of installed updates on the database.



# 10 SQL BI Check
Real-time monitoring for SSAS, viewing and analyzing consumption of CPU, memory and disk.



# 11 SQL Query Store Optimizer
Improving the performance of the Query Store service.



# 12 MySQL Query Explorer
Monitoring the MySQL resource-intensive top queries, viewing query execution statistics for tuning a database.



# 13 SQL Backup Status Reporter
Identification of databases that do not have backups, viewing the history of backups.



# 14 SQL Integrity Check
Able to run CHECKDB for SQL databases on demand.



# 15 SQL Job Manager
View current and past jobs.



# 16 PowerShell Plus
Special IDE for working with PowerShell scripts.



# 17 Rapid Database Extractor
Manage data sources for SQL and Oracle, manipulate database objects, execute SQL queries to retrieve data.



# 18 SQL Permissions Extractor
Able to generate T-SQL scripts to copy user permissions.



# 19 SQL Column Search
Search and export of sensitive data (credit card numbers and other personal data).



# 20 DBATools
Migration and Administration Module for SQL Server on Powershell.



# 00 PowerShell Scripts for SQL Server
Here they are! 89 scripts for managing SQL server, scripts for analysis, integration, reporting.



Effective use!