Using Spotlight 8.5, Entries of SQL in the PROCCACHE/Procedure Cache is using 800Kb and has a usecount of 1 and the only thing that changes is this line: set @PrevCallTime = '1358269188000'
Spotlight leaves some adhoc queries and particularly, QS_JobAlarts.sql leaves adhoc query by each execution and they won't be reused
Issue fixed in the current release of Spotlight on SQL Server Enterprise. To upgrade to the latest version without loss of existing connections and configurations, upgrade to Spotlight version 10.0 first. Contact <a href="https://support.quest.com/contact-support">support team</a> to obtain installers of previous versions of Spotlight.
