- We can implement something like https://github.com/etsy/statsd. This will collect and aggregate metrics.
- At pre-defined intervals (say... every 10 seconds), these metrics are flushed to a backend store
- We could use SQL Server to store the metrics:
#SQL Schema
- Each series is a seperate table containing a timestamp epoch (bigint) and a value (float)
- Rows are inserted, timestamp is the PK
#Example Query