check this opensource code and review the code. [login to view URL]
1. Modify OpenTelemetry Collector to send messages to ejdb database and amazon s3 or dropbox database. That way opentelemetry can be deployed on vm independently.
2. Would like to monitor sql server on windows. Develop client installer plugin for OpenTelemetry collector.
3. Frontend to be simplified with changes in clickhouse and query. Review further and simplify backend tables and query.