'how to know when we set turn on "optimize for ad hoc Workloads"?

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.

http://webcache.googleusercontent.com/search?q=cache:O-Uib9NXfI0J:https://blog.sqlauthority.com/2017/10/20/sql-server-turn-optimize-ad-hoc-workloads/&hl=en&gl=ir&strip=1&vwsrc=0

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

enter image description here

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

sql-server


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions