This custom alert calculates the average logical reads per execution for each query over the last 30 minutes (controllable by @CurrentTimeframeMins variable). It then compares this value to the historical average over the last 7 days (controllable by @HistoryTimeframeDays variable). The result will include any queries where the current average logical reads per execution is at least 2 times higher than the historical average.
To create this alert, create a Custom SQL Multiple Numeric Return alert and configure it similar to below. Ensure it runs against the DPA Repository:
