I'm having an application which generates SQL queries from EF library. When looking into the query plan cache on the test server I see that plans are getting frequently removed from there. Plan usually lives under a minute in there.
How can I debug what is the reason for such behavior? is there somewhere a clear event that states the reason?
