Find Uncached Sitecore Components

Sitecore recommends caching the HTML of renderings wherever it's practical to do so. Here's a quick SQL script to find View Renderings and Controller Renderings that are not marked as cacheable.

Run it against the web database

	SELECT Name, ID
	FROM Items
	WHERE TemplateID IN ('99F8905D-4A87-4EB8-9F8B-A9BEBFB3ADD6','2A3E91A0-7987-44B5-AB34-35C2D9DE83B9')
	AND ID IN (SELECT ItemID
	FROM SharedFields
	WHERE fieldid = '3D08DB46-2267-41B0-BC52-BE69FD618633'
	AND value ='1')

view raw UncachedSitecoreComponents.SQL hosted with ❤ by GitHub