Recently, I read an article with the below link and would like to know this property in my SQL server but the result is a kind of weird in my server.
Based on above link I try to gather information in my server into a table and know how much cache plan is associated with ad hoc queries but I can't interpret the results.
let me share it with you
The red lines showed the time I restart SQL server.
how to interpret this matter actually I don't know if I turned this setting on or leave it off by this result!!! your suggestion will be appreciated. best regards