New Year’s Resolution: Lose Weight in Your Database

 dans Sites anglophones  étiqueté indexing par

Made a New Year’s resolution to lose weight this year? Forget taking it off your waistline – take it off your database instead with:

sp_BlitzIndex @GetAllDatabases = 1, @Mode = 2, @SortOrder = ‘size’

Or:

sp_BlitzIndex @GetAllDatabases = 1, @Mode = 2, @SortOrder = ‘rows’

This produces an inventory of all the indexes sorted by size on disk or the number of rows, descending:

You can copy/paste that into Excel, send it around amongst your teams, and start having discussions like:

“Why do we have a 50GB heap called Sales_Backup_BeforeTheDeploy?” “Why do we have a 200GB table called ClickLog