• Hi

    Thanks a lot

    I Read cached_time field beside another fields. The result was frustrated. :crying:

    These are the result for one stored procedure :

    execution_count--- SelectTime ----------------- - cached_time

    96344----------- - 2016-05-01 11:15:51.470- 2016-05-01 10:57:03.880

    5528------------ - 2016-05-01 11:40:05.033- 2016-05-01 11:39:01.923

    27829----------- - 2016-05-01 11:44:39.920- 2016-05-01 11:39:01.923

    76949----------- - 2016-05-01 12:02:08.993- 2016-05-01 11:48:26.157

    It means that in average 10 minutes, plans of our stored procedures are removed from memory ?

    What should I do ?