I am looking for a system stat collection tool that will let me write queries against the data collected. I am planning to answer questions like:
what is the average load, over the last 30 days, on this machine between 9AM and 5PM, as opposed to at night
what was the average disk io on these 10 machines yesterday
what was the average daytime memory usage on these 10 machines last week, as opposed to 2 weeks ago
Has anyone done this with, say, collectd or graphite?