Can someone give me some assistance on the use case below?
Summary
To create a Key Performance Indicator (as a percent of server utilization where 0% is the best and 100% the worst) that will alert a user when one or more servers in a 30 server environment needs attention.
Details
Each server has three separate metrics shown below that will be calculated as a weighted average to come up with the final KPI. Each server reports its metrics at 5 minute intervals. I would like if possible for the formula to be flexible so I could report the KPI based on various time ranges (ie. 1 hour - 7 days)
1. CPU Utilization (45% weight)
2. Memory Utilization (45% weight)
3. Disk Input/Outpt (10% weight)
I've tried to use straight averages and with this for example if 1 server has 100% CPU and Memory it will quickly get drowned out if the other 29 servers are performing optimally
I've also tried using range, but found in larger time samples the range becomes too significant and could indicate a larger problem than it is in reality.
Summary
To create a Key Performance Indicator (as a percent of server utilization where 0% is the best and 100% the worst) that will alert a user when one or more servers in a 30 server environment needs attention.
Details
Each server has three separate metrics shown below that will be calculated as a weighted average to come up with the final KPI. Each server reports its metrics at 5 minute intervals. I would like if possible for the formula to be flexible so I could report the KPI based on various time ranges (ie. 1 hour - 7 days)
1. CPU Utilization (45% weight)
2. Memory Utilization (45% weight)
3. Disk Input/Outpt (10% weight)
I've tried to use straight averages and with this for example if 1 server has 100% CPU and Memory it will quickly get drowned out if the other 29 servers are performing optimally
I've also tried using range, but found in larger time samples the range becomes too significant and could indicate a larger problem than it is in reality.