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