Anyone know how to build a report that show percentage change for a given stat over a given period of time?
For example one that shows any volumes that have lost more than 10% of available space in last 24 hours or 10% of total size of disk.
Other examples include CPU % utilization that grows 25% or more suddenly, or an APM value. For example we track number of rows in a table in our database on all our servers. If it grows more than 15% in a day something is up. Or if the tempdb used space grows suddenly, this would be a great thing to trigger an alert for to make sure it doesn't eat up all the space on a drive.
I'd prefer to use a regular select/filter type, but if I had to I could use an advanced sql report. It's just orion does not handle filtering those per node on node views yet.
Thanks!