A lot of these scripts are thanks to Glenn Berry. Have a look at his scripts for everything you’ll ever need!

Get Hardware Info


Get Database Level Configs (recovery, log & common options)


Get Last Backup Times


Get Sizes Of All Databases


Get Table Sizes (database scoped)


Get CPU Utilisation By Database


Get IO Utilisation By Database


Get Top Avg. Elapsed Query Time On Instance


Get Most Frequently Executed Queries On Database


Get SQL Agent & Category Info


Get Database File Path & Growth Info


Get Fragmentation & Forward Record Counts


Get Database Growth Events


Get VLF Counts For All Databases