I am trying to create a custom report in diagnostic manager to show the worse performing sql server instances for certain counters. I notice that when I add PLE, it shows me the best not worst performing servers since higher PLE is better than lower PLE. How do I get the custom report to sort correctly? Is there some way to use a custom metric? Couldn't figure out how to create that correctly.
How are you creating the custom report? Through the SQLDM Desktop Client? The reason that I'm asking is that you mentioned "sql server instances" which suggests to me that the report is going to include several instances. When I build a custom report, each execution of the report is limited to a single instance.I don't think a custom metric would be needed here since SQLDM is already collecting data for that particular metric.
The metric is already being captured. the question is how to order the results for PLE from low to high since the default is high to low
thanks for saring