I have a SharePoint 2010 production farm where a Web Application running on port 90 always ends up with heavy memory usage , even during non-peak hours. My guess is some site has output cache enabled which is causing memory stress on the Web Servers.
Manually verifying this can be a daunting task as there are almost 70 site collections inside.
I'm interested in knowing if via Powershell this can be achieved perhaps by some logic that loops across all the site collections inside the web app searching for a condition that matches if the output cache is enabled. If this condition matches , it shows the name of the culprit site collection in the output window.