This question is locked. New answers and comments are not allowed.
After reading over the L2 cache documentation, I am not real sure how stored procedure or ad-hoc queries are managed in the cache? In my case, I do have a stored procedure that returns a somewhat compute intensive data set. As the data in this query is a composed from a number of tables, it was not clear to me how this type of call would be managed and ultimately refreshed in cache?