- Create simple DAX measures (Average, Min, and Max) and then Date Intelligence measures to support a comparison of performance monitoring counters against prior time periods or baselines:
Available Memory MB (Today) = CALCULATE([Available Memory (MB)],FILTER(ALL('Date'),'Date'[Date] = [Current Date]))Batch Requests per Sec (Yesterday) = CALCULATE([Batch Requests Per Sec],FILTER(ALL('Date'),'Date'[Date] = [Yesterday]))Min Available Memory MB (Today) = CALCULATE([Min Available Memory (MB)],FILTER(ALL('Date'),'Date'[Date] = [Current Date]),ALL('Time'))
- Create a report page based on the performance monitor counters that addresses top visibility needs such as "How is performance today?" and "How close are we to resource thresholds?" ...
