Metrics install automatically if you have Redgate Monitor installed.
If you are using Redgate’s SQL Server monitoring tool, Redgate Monitor, you can instantly install and run this metric on your servers.
This metric shows the percentage of query executions that have been able to reuse execution plans.
Metric definition
Name
Query execution reuse
Description
The percentage of query executions that have been able to reuse cached query plans.
The T-SQL query that will collect data
Instances to collect from
All
Databases to collect from
All
Collection frequency
60
Use collected or calculated values
Leave the Use a calculated rate of change between collections check box unchecked
Metric collection
Enabled
Alert definition
An alert for this metric can be created after establishing a baseline.