First things first: pick up that filthy keyboard, take it over to the trash can, turn it upside down, and give it a good, vigorous shake.
Next, go to your biggest SQL Server and run:
EXEC sp_BlitzIndex @GetAllDatabases = 1, @Mode = 2, @SortOrder = ‘rows’;
This will give you an inventory of all of the objects in your databases, ordered from biggest to smallest. Here’s what to look for:
Ask simple questions about the 10 biggest tables. Are they supposed to be this large, and contain this much history? Do we have history-deletion jobs that are supposed to be