Query execution reuse

Install metric...

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.