• We were examining plan cache size. Actually cache size of most of the adhoc queries are more than 40KB. We are working to convert them either parameterized or SPs.

    Thanks Gail.