Data collection
Custom SQL Query
Run custom SQL against Postgres, MySQL, SQL Server, Oracle or Snowflake and emit the result rows as metrics.
- Metrics
- Agentless
- Package 1.1.0
What it collects
- Signals
- Metrics
- How it collects
- Dedicated collector receiver (
sqlquery) - Where it runs
- Agentless: your workspace's cloud gateway can run it, with nothing to install. Collectors you install can run it too.
- Package version
- 1.1.0
How to connect it
- 01Open the connect wizardIn the Tracix console, open Integrations and pick Custom SQL Query.
- 02Choose where it runsAgentless runs it on your workspace's cloud gateway. Pick a policy to run it on collectors you install.
- 03Fill in the connectionEnter the settings the wizard asks for. Collectors pick up the policy change on their own.
More in databases
All packages in databases
PostgreSQL
Databases
Vacuum stats, bloat, replication lag, query latency, lock contention.
Metrics
MySQL
Databases
Connection pool, replication lag, slow query rate, table growth.
Metrics
SQL Server
Databases
Batch and transaction rates, waits, locks, top queries and live query samples from Microsoft SQL Server.
Metrics
MongoDB
Databases
Replication, sharding, ops/sec, page faults, lock state.
Metrics
Redis
Databases
Memory usage, hit rate, replication, persistence, slowlog.
Metrics
Elasticsearch
Databases
Cluster health, JVM heap, indices, search latency, indexing rate.
Metrics
Connect Custom SQL Query to Tracix
Start free and connect it from the console, or book a demo and we will walk through your environment with you.