Caches are a crucial component of every Sitecore instance – not only for an excellent content authoring experience, but also regarding launching or delivering your Sitecore site with optimized loading times.
A little story about challenges with Sitecore cache sizing…
Even though there are many best-practices for Sitecore cache sizing available – including a comprehensive doc on that – the optimal cache sizes for each environment and Sitecore instance can barely ever be sized appropriately right from the very beginning, resulting in a continuous optimization cycle. Additionally we might only touch those configurations once the Sitecore environment is in place for some time already and starts to show some signs of slowness here and there; only to find out that the use of the solution has probably grown quite a bit, whether in terms of visitors, or additional sites and marketers working in the system or simply the size of the database due to items, images and files.
How do you analyse Sitecore cache sizes today?
So whether you are sizing the Sitecore caches initially, or you are in an operational mode already and want to see a cache „healthcheck“ of your Sitecore solution, I guess you’ll be using the famous cache.aspx admin page.
- (+) Pros of the cache.aspx page: you’ll see each and every Sitecore cache with all relevant data.
- (–) Cons of the cache.aspx page: it’s hard to read and interpret – especially when we talk like hundreds of different caches…
A better Sitecore cache size analysis to the rescue
Let me share with you my magical „Sitecore cache.aspx analysis tool“
Already created some time ago – and heavily tested and used by our Sitecore specialists at Namics – the sheet is in a state I feel OK to share it. Sometimes it doesn’t take a lot for improving or supporting little tasks, but this sheet definitely does it’s job. And it’s compatible with all Sitecore versions coming with the cache.aspx admin page.
TL;DR! I want to get my hands on it now
- Google Spreadsheet version: click here to add a copy to your GDrive
- Microsoft Excel version: download file here
Here’s a how to you use it
- Open the cache.aspx page of your Sitecore instance: [yourpage]/sitecore/admin/cache.aspx
- Grab your Sitecore’s cache raw data by copy the text in the HTML cell from the top left to the very bottom right (attention: do not copy the column titles!)
- Open the „Sitecore cache.aspx analysis“-spreadsheet (or create a fresh copy)
- Select to the cell that indicates „Paste data here“
- Paste the copied cache raw data from the clipboard – preferably using „Insert values only“ (unformatted)
So long – happy cache sizes analysis!