Trend entries TTL and blank run detection required
I have created 20 trends to get the monthly reports without getting failed for delivery. But I have two issues now.
1.Trend entries are in millions but I don't need more than 30 days. How to set TTL like active list? Otherwise it will definitely impact DB performance.
2. Sometimes trends are not returning any data while query is returning in query viewer. It stops and do not show any run in refresh run as well. Enabling disabling also does not work. How to get notified if there is blank output after execution for any trend. This is big problems as at the end of the month we don't get data in the monthly report.
In trend you have an option called "Partition Retention Period" with which you could set to 30 days to hold your months data.
To answer your second query there are couple of things to be checked is the data in the trend to be empty in the mentioned period then you should look into the query used by the trend. If data is present and the report is empty then check the reports query.
The other possibility is the retention period as well check what is the current settings.
Varun P G