T-SQL: Check number of messages in distribution
With this command you can check the amount of transactions in the distribution database
0109, 2021
1607, 2020
2503, 2020
T-SQL: size of replication specific tables
On the distribution database, you can execute the statement below to get the sizes of the internal replication specific tables
2503, 2020
T-SQL: check replication backlog
You can use the code below on your distributor in order to check the backlog of the replication
1702, 2020
T-SQL: Resume or suspend all always on databases
You can use the t-sql code to resume/suspend all databases from the always on group.
2608, 2019
2608, 2019
2107, 2019
1407, 2019
Mysql: optimize all tables in all databases
In order to optimize all databases & tables within your mysql instance, you can use the code below. You can also use a more specific script, where only the tables are optimized which have 10MB free space and 10% free space.