This metric shows the percentage of cached plans that are being used more than once. If a plan is cached but never reused, there may be an opportunity to tune your server to work more effectively by rewriting the TSQL or creating a parameterized plan.
Plan cache reuse
Reuse of plans that are stored in the plan cache is important to the efficiency of SQL Server. Having the cache full of plans that are not reused is wasteful, and it means that there may be lots of queries not using the cache efficiently. If this metric is low then investigate the number of plans in your cache that have a usecount of 1 and see if any can be parameterized.
The T-SQL query that will collect data
Instances to collect from
Databases to collect from
Note: If you suspect that there may be an issue with plan cache reuse, increase the collection frequency to every minute so you can analyze more data.
Use collected or calculated values
Leave the Use a calculated rate of change between collections check box unchecked
An alert is not required