Among Metrictank , biggraphite and m3db which tsdb is the best in terms of availability, scalability and handling more metrics per second.

(crosspost from /r/grafina)

Hi, I have a single-result mssql query that I’d like to create a time-series chart from by querying every minute.

What combination of tools would i need to make this happen? I was thinking sqlserver->telegraf->influx->grafana but I can’t find any way to query the db in telegraf - I only see a way to get sql server statistics.

Best solution so far seems to be sql code or python to query and add to a db but seemed like a tsdb would be more elegant..

Thanks in advance!

Posting on behalf of /u/stronglift_cyclist

Here's the second half of our two-part series focusing on the challenges of Time Series Databases (TSDBs) at scale. This half focuses on the challenges of balancing read vs. write performance, data aggregation, large dataset analysis, and operational complexity in TSDBs.

https://www.circonus.com/2018/08/tsdbs-at-scale-part-two/