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 ?