Today we explore some of the challenges with ignoring maintenance of your Sitecore installation.
Recently I found over 60% of the Sitecore master/web databases were consumed by orphaned blob records. I believe this behavior is experienced when detaching data from an existing media item or deleting the media item. The Blobs table contains this orphaned record until another process is triggered to purge the data. There have been several prior articles discussing this issue so I'm simply going to outline what I discovered along the way.
The part you care about
Database details prior to cleanup
- We ran this on Sitecore XM 10.2 and 10.4
- Consult with Sitecore support first if you are having a similar issue
- The MDF file was approaching 60GB with over 90% used space
- Total blob records in the table - 127,300
- Total unused blob records - 104,466
- 59,353 distinct BlobId values
- The MDF file now shows used space at 8% (4.7GB)
- Total blob records in the table - 22,867
The following script was used against a Sitecore XM 10.2 database. Proceed with caution.
One script that I found particular helpful was one that helped me periodically check the row count of the Blobs table.
