This page describes Darling v3.13.0. The source of this page is on GitHub at that version.
Audience: operators, and anyone who builds on the store.
This page lists every Darling MCP tool and the store objects that its SQL uses. Use it to find the collector behind a tool, or to choose the tables to keep when you copy the store to another place.
How to read the tables
- Store objects are tables, views and continuous aggregates in the store’s
collectandconfigschemas. - When a tool reads a view or a continuous aggregate, the page names the base table first. The view or aggregate follows in parentheses.
- A note in parentheses after a table, such as
(only when tag given), means that the tool reads the table only in that case. - For a tool that changes something,
(insert),(update)and(delete)show what the tool does to each table. Tables that such a tool only reads have no note. - The page leaves out the lookups that almost every tool makes. These are the server name against
config.config_monitored_serversandcollect.servers, the server tags, and the token and audit checks. A tool’s row names these tables only when the tool’s answer comes from them, as withlist_servers.
Limits
- The page matches the
devbranch at the commit that last changed it, with the store at schema version 232. Thetools/listcall on a running server gives the full list for that build. - A tool that has no row here was added after this page. A changed tool can read other tables than the ones shown here.
- Which tools a server serves depends on the
mcpswitches. See MCP configuration. - The page was made by reading each tool’s code down to the SQL that runs. It was not made from a store trace.
Tools that read collected data (154)
| Tool | Store objects |
|---|---|
analyze_procedure_plan |
collect.procedure_statscollect.query_plan_dimcollect.server_propertiescollect.server_config |
analyze_query_plan |
collect.query_stats (through the view collect.v_query_stats)collect.query_plan_dimcollect.server_propertiescollect.server_configcollect.database_config |
analyze_query_store_plan |
collect.query_store_plan_mapcollect.query_plan_dimcollect.query_store_statscollect.server_propertiescollect.server_configcollect.database_configconfig.config_service |
analyze_server |
SQL Server targets:collect.wait_statscollect.deadlockscollect.blocked_process_reportscollect.dmv_blocking_snapshotscollect.query_statscollect.query_store_statscollect.query_store_interval_widecollect.query_store_interval_latestcollect.query_store_textcollect.query_store_plan_mapcollect.query_plan_dimcollect.query_text_dimcollect.plan_regression_dailycollect.procedure_statscollect.plan_cache_statscollect.query_snapshotscollect.running_jobscollect.session_statscollect.cpu_utilization_statscollect.memory_statscollect.memory_grant_statscollect.memory_clerkscollect.memory_pressure_eventscollect.perfmon_statscollect.file_io_statscollect.tempdb_statscollect.database_size_statscollect.database_configcollect.server_configcollect.server_propertiescollect.trace_flagscollect.index_object_statscollect.default_trace_eventscollect.collection_logcollect.ag_replica_statescollect.ag_database_replica_statescollect.v_wait_statscollect.v_deadlockscollect.v_blocked_process_reportscollect.v_dmv_blocking_snapshotscollect.v_query_statscollect.v_query_store_statscollect.v_query_snapshotscollect.v_session_statscollect.v_cpu_utilization_statscollect.v_memory_statscollect.v_memory_grant_statscollect.v_perfmon_statscollect.v_file_io_statscollect.v_tempdb_statscollect.v_database_size_statscollect.v_database_configcollect.v_index_object_statsAnomaly baselines: collect.wait_stats (through the continuous aggregate collect.wait_stats_interval_baseline)collect.wait_stats_baseline (a retired continuous aggregate)collect.perfmon_stats (through the continuous aggregate collect.perfmon_interval_baseline)collect.perfmon_baseline (a retired continuous aggregate)collect.session_stats (through the continuous aggregate collect.session_stats_baseline)collect.query_stats (through the continuous aggregate collect.query_stats_baseline)collect.memory_stats (through the continuous aggregate collect.memory_baseline)collect.blocked_process_reports (through the continuous aggregate collect.blocked_process_baseline)collect.deadlock_baselinecollect.cpu_utilization_statscollect.file_io_statsPostgreSQL targets: collect.pg_server_configcollect.pg_statement_statscollect.pg_statement_textcollect.pg_database_statscollect.pg_database_size_statscollect.pg_wait_statscollect.pg_wait_samplingcollect.pg_cpu_utilizationcollect.pg_session_statescollect.pg_write_statscollect.pg_extension_availabilitycollect.pg_plan_capturecollect.pg_plan_capture_readinesscollect.pg_io_statscollect.pg_replication_statscollect.pg_replication_slot_statscollect.pg_log_eventscollect.pg_kernel_statscollect.pg_buffer_usagecollect.pg_blocking_edgescollect.pg_xmin_horizoncollect.pg_wraparound_statscollect.pg_table_bloat_statscollect.pg_index_bloatcollect.pg_predicate_statscollect.pg_deadlockscollect.pg_column_statscollect.pg_autovacuum_statsForce-plan remediation state: collect.query_store_statscollect.plan_correctioncollect.analysis_findingsconfig.analysis_muted |
audit_config |
SQL Server targets:collect.server_configcollect.server_propertiescollect.memory_statscollect.file_io_statsPostgreSQL targets: collect.pg_server_configcollect.pg_autovacuum_stats |
backtest_custom_alert_rule |
The table that the rule’s measure names. Also its hourly or daily aggregate, when the window uses one.config.custom_alert_rules (when rule_id given)config.server_tagsconfig.server_tag_mapconfig.config_collector_schedules |
compare_analysis |
SQL Server targets:collect.wait_statscollect.deadlockscollect.blocked_process_reportscollect.dmv_blocking_snapshotscollect.query_statscollect.query_store_statscollect.query_store_interval_widecollect.query_store_interval_latestcollect.query_store_textcollect.query_store_plan_mapcollect.query_plan_dimcollect.query_text_dimcollect.plan_regression_dailycollect.procedure_statscollect.plan_cache_statscollect.query_snapshotscollect.running_jobscollect.session_statscollect.cpu_utilization_statscollect.memory_statscollect.memory_grant_statscollect.memory_clerkscollect.memory_pressure_eventscollect.perfmon_statscollect.file_io_statscollect.tempdb_statscollect.database_size_statscollect.database_configcollect.server_configcollect.server_propertiescollect.trace_flagscollect.index_object_statscollect.default_trace_eventscollect.collection_logcollect.ag_replica_statescollect.ag_database_replica_statescollect.v_wait_statscollect.v_deadlockscollect.v_blocked_process_reportscollect.v_dmv_blocking_snapshotscollect.v_query_statscollect.v_query_store_statscollect.v_query_snapshotscollect.v_session_statscollect.v_cpu_utilization_statscollect.v_memory_statscollect.v_memory_grant_statscollect.v_perfmon_statscollect.v_file_io_statscollect.v_tempdb_statscollect.v_database_size_statscollect.v_database_configcollect.v_index_object_statsAnomaly baselines: collect.wait_stats (through the continuous aggregate collect.wait_stats_interval_baseline)collect.wait_stats_baseline (a retired continuous aggregate)collect.perfmon_stats (through the continuous aggregate collect.perfmon_interval_baseline)collect.perfmon_baseline (a retired continuous aggregate)collect.session_stats (through the continuous aggregate collect.session_stats_baseline)collect.query_stats (through the continuous aggregate collect.query_stats_baseline)collect.memory_stats (through the continuous aggregate collect.memory_baseline)collect.blocked_process_reports (through the continuous aggregate collect.blocked_process_baseline)collect.deadlock_baselinecollect.cpu_utilization_statscollect.file_io_statsPostgreSQL targets: collect.pg_server_configcollect.pg_statement_statscollect.pg_statement_textcollect.pg_database_statscollect.pg_database_size_statscollect.pg_wait_statscollect.pg_wait_samplingcollect.pg_cpu_utilizationcollect.pg_session_statescollect.pg_write_statscollect.pg_extension_availabilitycollect.pg_plan_capturecollect.pg_plan_capture_readinesscollect.pg_io_statscollect.pg_replication_statscollect.pg_replication_slot_statscollect.pg_log_eventscollect.pg_kernel_statscollect.pg_buffer_usagecollect.pg_blocking_edgescollect.pg_xmin_horizoncollect.pg_wraparound_statscollect.pg_table_bloat_statscollect.pg_index_bloatcollect.pg_predicate_statscollect.pg_deadlockscollect.pg_column_statscollect.pg_autovacuum_stats |
find_database |
collect.database_statescollect.servers |
find_queries_by_text |
collect.query_store_textcollect.query_statscollect.query_text_dimcollect.servers |
find_schema_objects |
collect.schema_objectscollect.schema_columnscollect.schema_constraintscollect.schema_indexescollect.schema_capture_statecollect.ag_database_replica_statescollect.servers |
get_active_queries |
collect.query_snapshotsconfig.query_tag_map (only when tag given)config.query_tags (only when tag given) |
get_active_query_plan_xml |
collect.query_snapshots |
get_agent_alerts |
collect.agent_alertscollect.serverscollect.collection_log |
get_ag_health |
collect.ag_replica_statescollect.ag_database_replica_states |
get_alert_history |
config.config_alert_log |
get_analysis_facts |
SQL Server targets:collect.wait_statscollect.deadlockscollect.blocked_process_reportscollect.dmv_blocking_snapshotscollect.query_statscollect.query_store_statscollect.query_store_interval_widecollect.query_store_interval_latestcollect.query_store_textcollect.query_store_plan_mapcollect.query_plan_dimcollect.query_text_dimcollect.plan_regression_dailycollect.procedure_statscollect.plan_cache_statscollect.query_snapshotscollect.running_jobscollect.session_statscollect.cpu_utilization_statscollect.memory_statscollect.memory_grant_statscollect.memory_clerkscollect.memory_pressure_eventscollect.perfmon_statscollect.file_io_statscollect.tempdb_statscollect.database_size_statscollect.database_configcollect.server_configcollect.server_propertiescollect.trace_flagscollect.index_object_statscollect.default_trace_eventscollect.collection_logcollect.ag_replica_statescollect.ag_database_replica_statescollect.v_wait_statscollect.v_deadlockscollect.v_blocked_process_reportscollect.v_dmv_blocking_snapshotscollect.v_query_statscollect.v_query_store_statscollect.v_query_snapshotscollect.v_session_statscollect.v_cpu_utilization_statscollect.v_memory_statscollect.v_memory_grant_statscollect.v_perfmon_statscollect.v_file_io_statscollect.v_tempdb_statscollect.v_database_size_statscollect.v_database_configcollect.v_index_object_statsAnomaly baselines: collect.wait_stats (through the continuous aggregate collect.wait_stats_interval_baseline)collect.wait_stats_baseline (a retired continuous aggregate)collect.perfmon_stats (through the continuous aggregate collect.perfmon_interval_baseline)collect.perfmon_baseline (a retired continuous aggregate)collect.session_stats (through the continuous aggregate collect.session_stats_baseline)collect.query_stats (through the continuous aggregate collect.query_stats_baseline)collect.memory_stats (through the continuous aggregate collect.memory_baseline)collect.blocked_process_reports (through the continuous aggregate collect.blocked_process_baseline)collect.deadlock_baselinecollect.cpu_utilization_statscollect.file_io_statsPostgreSQL targets: collect.pg_server_configcollect.pg_statement_statscollect.pg_statement_textcollect.pg_database_statscollect.pg_database_size_statscollect.pg_wait_statscollect.pg_wait_samplingcollect.pg_cpu_utilizationcollect.pg_session_statescollect.pg_write_statscollect.pg_extension_availabilitycollect.pg_plan_capturecollect.pg_plan_capture_readinesscollect.pg_io_statscollect.pg_replication_statscollect.pg_replication_slot_statscollect.pg_log_eventscollect.pg_kernel_statscollect.pg_buffer_usagecollect.pg_blocking_edgescollect.pg_xmin_horizoncollect.pg_wraparound_statscollect.pg_table_bloat_statscollect.pg_index_bloatcollect.pg_predicate_statscollect.pg_deadlockscollect.pg_column_statscollect.pg_autovacuum_stats |
get_analysis_findings |
collect.analysis_findingsconfig.analysis_mutedcollect.query_store_statscollect.plan_correctioncollect.ag_replica_statescollect.ag_database_replica_states |
get_blocked_process_xml |
collect.blocked_process_reports |
get_blocking |
collect.blocked_process_reportscollect.dmv_blocking_snapshots (through the view collect.v_dmv_blocking_snapshots) |
get_blocking_plan_xml |
collect.blocked_process_reports |
get_blocking_stats |
collect.blocked_process_reportscollect.dmv_blocking_snapshotscollect.deadlockscollect.collection_logcollect.v_blocked_process_reportscollect.v_dmv_blocking_snapshotscollect.v_deadlocks |
get_blocking_trend |
collect.blocked_process_reports (through the view collect.v_blocked_process_reports)collect.dmv_blocking_snapshots (through the view collect.v_dmv_blocking_snapshots)collect.collection_log (through the view collect.v_collection_log) |
get_client_timeouts |
collect.attention_eventscollect.collection_log |
get_compiles_after_evict |
config.investigation_journalcollect.query_statscollect.procedure_stats |
get_cpu_by_database |
collect.query_statscollect.query_stats (through the continuous aggregate collect.query_stats_io_hourly)collect.procedure_statscollect.procedure_stats (through the continuous aggregate collect.procedure_stats_io_hourly)collect.query_text_dim |
get_cpu_scheduler_pressure |
collect.cpu_scheduler_stats (through the view collect.v_cpu_scheduler_stats) |
get_cpu_utilization |
collect.cpu_utilization_stats |
get_current_waits_trend |
collect.waiting_tasks |
get_daily_health_report |
collect.serverscollect.cpu_utilization_statscollect.pg_cpu_utilizationcollect.memory_statscollect.memory_grant_statscollect.cpu_scheduler_statscollect.blocked_process_reports (through a view)collect.dmv_blocking_snapshots (through a view)collect.deadlocks (through a view)collect.pg_database_statscollect.collection_logcollect.collection_log (through the continuous aggregate collect.collection_health_hourly)config.config_mute_rulesconfig.config_alert_settingsconfig.server_tagsconfig.server_tag_mapconfig.config_serviceconfig.config_commandcollect.v_cpu_utilization_statscollect.v_memory_statscollect.v_memory_grant_statscollect.v_cpu_scheduler_statscollect.v_collection_logconfig.config_alert_logcollect.job_historycollect.server_propertiescollect.agent_statuscollect.database_size_stats |
get_daily_summary |
collect.wait_stats (through the view collect.v_wait_stats)collect.query_stats (through the view collect.v_query_stats)collect.deadlocks (through the view collect.v_deadlocks)collect.blocked_process_reports (through the view collect.v_blocked_process_reports)collect.dmv_blocking_snapshots (through the view collect.v_dmv_blocking_snapshots)collect.cpu_utilization_stats (through the view collect.v_cpu_utilization_stats)collect.collection_log (through the view collect.v_collection_log)collect.memory_pressure_events (through the view collect.v_memory_pressure_events)config.config_alert_logconfig.config_alert_settingsconfig.config_collector_schedulescollect.query_stats_hourlycollect.query_stats_interval_hourlycollect.query_stats_daily |
get_daily_summary_range |
collect.wait_stats (through the view collect.v_wait_stats)collect.query_stats (through the view collect.v_query_stats)collect.deadlocks (through the view collect.v_deadlocks)collect.blocked_process_reports (through the view collect.v_blocked_process_reports)collect.dmv_blocking_snapshots (through the view collect.v_dmv_blocking_snapshots)collect.cpu_utilization_stats (through the view collect.v_cpu_utilization_stats)collect.collection_log (through the view collect.v_collection_log)collect.memory_pressure_events (through the view collect.v_memory_pressure_events)config.config_alert_logconfig.config_alert_settingsconfig.config_collector_schedulescollect.query_stats_hourlycollect.query_stats_interval_hourlycollect.query_stats_daily |
get_database_config |
collect.database_configcollect.v_database_config |
get_database_config_changes |
collect.database_configcollect.v_database_config |
get_database_protection |
collect.database_protectioncollect.serverscollect.collection_log |
get_database_scoped_config |
collect.database_scoped_configcollect.v_database_scoped_config |
get_database_sizes |
collect.database_size_stats (through the view collect.v_database_size_stats) |
get_database_state_expectations |
collect.database_statesconfig.database_state_expected |
get_deadlock_detail |
collect.deadlocks |
get_deadlock_plan_xml |
collect.deadlocks |
get_deadlock_trend |
collect.deadlocks (through the view collect.v_deadlocks)collect.collection_log (through the view collect.v_collection_log) |
get_deadlocks |
collect.deadlocks |
get_default_trace_events |
collect.default_trace_eventscollect.server_properties |
get_file_io_stats |
collect.file_io_statscollect.v_file_io_stats |
get_file_io_trend |
collect.file_io_statscollect.v_file_io_stats |
get_finops |
The tables depend on view:collect.cpu_utilization_statscollect.memory_stats (through a view)collect.memory_grant_stats (through a view)collect.server_propertiescollect.index_object_statscollect.database_statescollect.query_statscollect.file_io_stats (through a view)collect.query_stats (through the continuous aggregate collect.query_stats_hourly or collect.query_stats_daily)collect.query_stats (through the continuous aggregate collect.query_stats_db_hourly or collect.query_stats_db_daily)collect.session_statscollect.database_size_statscollect.query_stats (through a view)collect.tempdb_stats (through a view)collect.wait_stats (through a view)collect.query_text_dimcollect.query_plan_dimcollect.index_object_stats (through a view)collect.servers |
get_finops_inventory |
collect.serverscollect.server_propertiescollect.cpu_utilization_statscollect.memory_statscollect.memory_grant_statscollect.database_size_statscollect.query_statscollect.query_stats (through the continuous aggregate collect.query_stats_db_hourly)collect.query_stats (through the continuous aggregate collect.query_stats_db_interval_hourly)collect.collection_logcollect.v_cpu_utilization_statscollect.v_memory_statscollect.v_memory_grant_statscollect.v_database_size_statscollect.v_query_statscollect.v_collection_log |
get_finops_recommendations |
collect.serverscollect.server_propertiescollect.memory_statscollect.running_jobscollect.file_io_statscollect.cpu_utilization_statscollect.memory_grant_statscollect.database_configcollect.database_size_statscollect.index_object_statscollect.query_statscollect.database_statescollect.ag_replica_statescollect.ag_database_replica_statescollect.v_memory_statscollect.v_running_jobscollect.v_file_io_statscollect.v_cpu_utilization_statscollect.v_memory_grant_statscollect.v_database_configcollect.v_database_size_statscollect.v_index_object_statscollect.v_query_stats |
get_fleet_overview |
collect.serverscollect.cpu_utilization_statscollect.pg_cpu_utilizationcollect.memory_statscollect.memory_grant_statscollect.cpu_scheduler_statscollect.blocked_process_reports (through a view)collect.dmv_blocking_snapshots (through a view)collect.deadlocks (through a view)collect.pg_database_statscollect.collection_logcollect.collection_log (through the continuous aggregate collect.collection_health_hourly)config.config_mute_rulesconfig.config_alert_settingsconfig.server_tagsconfig.server_tag_mapconfig.config_serviceconfig.config_commandcollect.v_cpu_utilization_statscollect.v_memory_statscollect.v_memory_grant_statscollect.v_cpu_scheduler_statscollect.v_collection_log |
get_forced_plans |
collect.query_store_forced_planscollect.query_store_plan_mapcollect.query_plan_dimcollect.query_store_statscollect.v_query_store_stats |
get_health_parser_cpu_tasks |
collect.system_health_eventscollect.collection_logcollect.v_system_health_eventscollect.v_collection_log |
get_health_parser_io_issues |
collect.system_health_eventscollect.collection_logcollect.v_system_health_eventscollect.v_collection_log |
get_health_parser_memory_broker |
collect.system_health_eventscollect.collection_logcollect.v_system_health_eventscollect.v_collection_log |
get_health_parser_memory_conditions |
collect.system_health_eventscollect.collection_logcollect.v_system_health_eventscollect.v_collection_log |
get_health_parser_memory_node_oom |
collect.system_health_eventscollect.collection_logcollect.v_system_health_eventscollect.v_collection_log |
get_health_parser_scheduler_issues |
collect.system_health_eventscollect.collection_logcollect.v_system_health_eventscollect.v_collection_log |
get_health_parser_severe_errors |
collect.system_health_eventscollect.collection_logcollect.database_size_statscollect.v_system_health_eventscollect.v_collection_logcollect.v_database_size_stats |
get_health_parser_significant_waits |
collect.system_health_eventscollect.collection_logcollect.v_system_health_eventscollect.v_collection_log |
get_health_parser_system_health |
collect.system_health_eventscollect.collection_logcollect.v_system_health_eventscollect.v_collection_log |
get_identity_capacity |
collect.identity_capacitycollect.servers |
get_index_usage |
collect.index_object_stats (through the view collect.v_index_object_stats) |
get_job_history |
collect.job_historycollect.server_propertiescollect.serverscollect.agent_statusconfig.config_alert_settings |
get_latch_stats |
collect.latch_stats (through the view collect.v_latch_stats) |
get_load_by_caller |
collect.query_snapshots |
get_lock_wait_trend |
collect.wait_stats (through the view collect.v_wait_stats) |
get_long_query_completions |
collect.long_query_completions |
get_memory_clerks |
collect.memory_clerkscollect.v_memory_clerks |
get_memory_grants |
collect.memory_grant_stats (through the view collect.v_memory_grant_stats) |
get_memory_pressure_events |
collect.memory_pressure_events (through the view collect.v_memory_pressure_events) |
get_memory_stats |
collect.memory_statscollect.v_memory_stats |
get_memory_trend |
collect.memory_statscollect.memory_grant_statscollect.v_memory_statscollect.v_memory_grant_stats |
get_object_definition |
collect.schema_objectscollect.schema_columnscollect.schema_indexescollect.schema_constraintscollect.schema_triggerscollect.schema_capture_statecollect.ag_database_replica_statescollect.servers |
get_object_locking |
collect.index_object_stats (through the view collect.v_index_object_stats)collect.database_config |
get_perfmon_stats |
collect.perfmon_statscollect.v_perfmon_stats |
get_perfmon_trend |
collect.perfmon_statscollect.v_perfmon_stats |
get_pg_autovacuum_health |
collect.pg_autovacuum_statscollect.pg_log_events |
get_pg_blocking |
collect.pg_blocking_edgescollect.collection_log |
get_pg_buffer_usage |
collect.pg_buffer_usage |
get_pg_column_stats |
collect.pg_column_statscollect.pg_table_bloat_statscollect.collection_log |
get_pg_cpu_utilization |
collect.pg_cpu_utilization |
get_pg_database_stats |
collect.pg_database_stats |
get_pg_database_trend |
collect.pg_database_stats |
get_pg_deadlock_detail |
collect.pg_deadlocks |
get_pg_deadlocks |
collect.pg_deadlocks |
get_pg_extensions |
collect.pg_extension_availability |
get_pg_index_bloat |
collect.pg_index_bloatcollect.collection_log |
get_pg_index_usage |
collect.pg_index_usage_stats |
get_pg_io_stats |
collect.pg_io_statscollect.pg_io_stats_hourlycollect.pg_io_stats_hourly_statecollect.pg_server_config |
get_pg_io_trend |
collect.pg_io_statscollect.pg_server_config |
get_pg_kernel_stats |
collect.pg_kernel_stats |
get_pg_lock_stats |
collect.pg_lock_stats |
get_pg_log_events |
collect.pg_log_events |
get_pg_logging_audit |
collect.pg_server_config |
get_pg_plan_capture_readiness |
collect.pg_plan_capture_readiness |
get_pg_plans |
collect.pg_plan_capturecollect.pg_plan_capture_readiness |
get_pg_predicate_stats |
collect.pg_predicate_stats |
get_pg_query_duration_trend |
collect.pg_statement_stats |
get_pg_replication_slots |
collect.pg_replication_slot_stats |
get_pg_replication_stats |
collect.pg_replication_stats |
get_pg_server_config |
collect.pg_server_config |
get_pg_server_config_changes |
collect.pg_server_configcollect.darling_schema_version |
get_pg_session_states |
collect.pg_session_statescollect.collection_log |
get_pg_table_bloat |
collect.pg_table_bloat_stats |
get_pg_top_queries |
collect.pg_statement_statscollect.pg_statement_textcollect.pg_server_configcollect.collection_logcollect.v_collection_log |
get_pg_wait_sampling |
collect.pg_wait_samplingcollect.collector_state |
get_pg_wait_stats |
collect.pg_wait_stats |
get_pg_wait_trend |
collect.pg_wait_samplingcollect.pg_wait_statscollect.collector_state |
get_pg_wraparound_risk |
collect.pg_wraparound_stats |
get_pg_write_stats |
collect.pg_write_stats |
get_pg_xmin_horizon |
collect.pg_xmin_horizoncollect.collection_log |
get_plan_cache_bloat |
collect.plan_cache_stats (through the view collect.v_plan_cache_stats) |
get_plan_corrections |
collect.plan_correction |
get_plan_force_precheck |
collect.query_store_statscollect.query_store_interval_widecollect.query_store_textcollect.query_store_health (through the view collect.v_query_store_health)collect.index_object_stats (through the view collect.v_index_object_stats)collect.job_historycollect.plan_correctioncollect.analysis_findingscollect.servers |
get_plan_xml |
collect.query_stats (through the view collect.v_query_stats)collect.query_plan_dim |
get_procedure_duration_trend |
collect.procedure_statscollect.procedure_stats (through the continuous aggregate collect.procedure_stats_hourly)collect.procedure_stats (through the continuous aggregate collect.procedure_stats_interval_hourly)collect.procedure_stats (through the continuous aggregate collect.procedure_stats_daily)collect.collection_log |
get_procedure_plan_xml |
collect.procedure_statscollect.query_plan_dim |
get_pvs_stats |
collect.pvs_stats (through the view collect.v_pvs_stats) |
get_query_duration_trend |
collect.query_statscollect.query_stats (through the continuous aggregate collect.query_stats_hourly)collect.query_stats (through the continuous aggregate collect.query_stats_interval_hourly)collect.query_stats (through the continuous aggregate collect.query_stats_daily)collect.query_stats_interval_daily (continuous aggregate) |
get_query_fleet_summary |
collect.serverscollect.query_statscollect.query_stats (through the continuous aggregate collect.query_stats_hourly)collect.query_stats (through the continuous aggregate collect.query_stats_interval_hourly)collect.query_stats (through the continuous aggregate collect.query_stats_daily)collect.query_store_statscollect.query_store_stats (through the continuous aggregate collect.query_store_stats_corrected_hourly) |
get_query_heatmap |
collect.query_statscollect.query_text_dim |
get_query_pileups |
collect.query_snapshotscollect.dmv_blocking_snapshots |
get_query_repro_script |
collect.query_stats (through the view collect.v_query_stats)collect.query_store_textcollect.query_store_statscollect.query_snapshotscollect.query_plan_dimcollect.server_propertiescollect.server_configcollect.database_config |
get_query_store_aborts |
collect.query_store_statscollect.query_store_interval_widecollect.query_store_text |
get_query_store_clutter |
collect.collection_log (through the view collect.v_collection_log)collect.query_store_statscollect.query_store_health (through the view collect.v_query_store_health)collect.wait_stats (through the view collect.v_wait_stats)collect.memory_clerks (through the view collect.v_memory_clerks) |
get_query_store_duration_trend |
collect.query_store_statscollect.query_store_stats_interval_hourly (through the continuous aggregate collect.query_store_stats_corrected_hourly) |
get_query_store_health |
collect.query_store_healthcollect.v_query_store_health |
get_query_store_hints |
collect.query_store_hintscollect.query_store_textcollect.query_store_stats |
get_query_store_plan_xml |
collect.query_store_plan_mapcollect.query_plan_dimcollect.query_store_statsconfig.config_service |
get_query_store_query_history |
collect.query_store_statscollect.query_store_interval_widecollect.query_store_forced_planscollect.query_store_plan_mapcollect.query_plan_dim |
get_query_store_regressions |
collect.query_store_statscollect.query_store_interval_widecollect.query_store_interval_latestcollect.plan_regression_dailycollect.query_store_text |
get_query_store_top |
collect.query_store_statscollect.query_store_interval_widecollect.query_store_top_dailycollect.query_store_top_daily_builtcollect.query_store_textcollect.collection_log |
get_query_trend |
collect.query_statscollect.query_stats (through the continuous aggregate collect.query_stats_hourly)collect.query_stats (through the continuous aggregate collect.query_stats_interval_hourly)collect.query_stats (through the continuous aggregate collect.query_stats_daily) |
get_resource_semaphore |
collect.memory_grant_stats (through the view collect.v_memory_grant_stats) |
get_resource_use_by_tag |
config.query_tagsconfig.query_tag_mapcollect.query_statscollect.query_stats (through the continuous aggregate collect.query_stats_io_hourly)collect.query_store_interval_widecollect.query_store_hash_hourlycollect.query_store_hash_dailycollect.procedure_statscollect.procedure_stats (through the continuous aggregate collect.procedure_stats_io_hourly)collect.blocked_process_reportscollect.dmv_blocking_snapshotscollect.deadlocks |
get_running_jobs |
collect.running_jobs (through the view collect.v_running_jobs)collect.collection_log (through the view collect.v_collection_log) |
get_schema_changes |
collect.schema_objectscollect.schema_columnscollect.schema_indexescollect.schema_constraintscollect.schema_triggerscollect.schema_capture_statecollect.ag_database_replica_statescollect.servers |
get_server_config |
collect.server_configcollect.v_server_config |
get_server_config_changes |
collect.server_configcollect.v_server_config |
get_server_properties |
collect.server_properties |
get_server_summary |
collect.cpu_utilization_stats (through the view collect.v_cpu_utilization_stats)collect.memory_stats (through the view collect.v_memory_stats)collect.blocked_process_reports (through the view collect.v_blocked_process_reports)collect.dmv_blocking_snapshots (through the view collect.v_dmv_blocking_snapshots)collect.deadlocks (through the view collect.v_deadlocks)collect.collection_log (through the view collect.v_collection_log) |
get_server_trend |
collect.wait_stats (through the view collect.v_wait_stats)collect.cpu_scheduler_stats (through the view collect.v_cpu_scheduler_stats)collect.memory_clerks (through the view collect.v_memory_clerks)collect.plan_cache_stats (through the view collect.v_plan_cache_stats)collect.latch_stats (through the view collect.v_latch_stats)collect.spinlock_stats (through the view collect.v_spinlock_stats)collect.session_summary_stats (through the view collect.v_session_summary_stats)collect.collection_log (through the view collect.v_collection_log)collect.file_io_stats (through the view collect.v_file_io_stats)collect.tempdb_stats (through the view collect.v_tempdb_stats) |
get_session_stats |
collect.session_statscollect.v_session_stats |
get_spinlock_stats |
collect.spinlock_stats (through the view collect.v_spinlock_stats) |
get_sweep_reports |
collect.fleet_sweep_runscollect.fleet_sweep_server_verdictscollect.fleet_sweep_would_have_pagedcollect.fleet_sweep_watch_items |
get_table_index_sizes |
collect.index_object_stats (through the view collect.v_index_object_stats) |
get_tempdb_trend |
collect.tempdb_statscollect.v_tempdb_stats |
get_top_procedures_by_cpu |
collect.procedure_statscollect.cpu_utilization_statscollect.server_propertiescollect.procedure_stats (through the continuous aggregate collect.procedure_stats_hourly)collect.procedure_stats (through the continuous aggregate collect.procedure_stats_interval_hourly)collect.procedure_stats (through the continuous aggregate collect.procedure_stats_io_hourly)collect.collection_log |
get_top_queries_by_cpu |
collect.query_statscollect.query_text_dimcollect.cpu_utilization_statscollect.server_propertiescollect.query_stats (through the continuous aggregate collect.query_stats_hourly)collect.query_stats (through the continuous aggregate collect.query_stats_interval_hourly)collect.query_stats (through the continuous aggregate collect.query_stats_io_hourly)collect.collection_log |
get_trace_flag_changes |
collect.trace_flagscollect.collection_logcollect.v_trace_flagscollect.v_collection_log |
get_trace_flags |
collect.trace_flagscollect.collection_logcollect.v_trace_flagscollect.v_collection_log |
get_wait_stats |
collect.wait_statscollect.v_wait_stats |
get_wait_trend |
collect.wait_statscollect.collection_logcollect.collector_statecollect.v_wait_stats |
get_wait_types |
collect.wait_statscollect.v_wait_stats |
get_waiting_tasks |
collect.waiting_tasks |
run_custom_view_panel |
The table that the panel’s measure names. Also its hourly or daily aggregate, when the window uses one.collect.module_map (module join)collect.servers (query_store_interval_wide join)config.query_tag_map |
test_custom_alert_rule |
The table that the rule’s measure names. Also its hourly or daily aggregate, when the window uses one.config.custom_alert_rules (when rule_id given)config.server_tagsconfig.server_tag_map (tag scope) |
test_query_tag_rule |
collect.query_tag_sightingsconfig.query_tag_rulesconfig.query_tagsconfig.query_tag_assignmentscollect.servers |
Tools about Darling itself (40)
| Tool | Store objects |
|---|---|
analyze_plan_xml |
None. It analyses the plan XML that you pass in. |
describe_custom_view_catalog |
None. The catalog is built into the service. |
get_agent_changes |
config.investigation_journalconfig.config_alert_logconfig.investigation_requestsconfig.investigation_evidenceconfig.config_servicecollect.servers |
get_alert_settings |
config.config_alert_settingsconfig.config_notificationconfig.config_threshold_overrides |
get_change_watches |
config.change_watchesconfig.change_watch_changes |
get_collection_health |
collect.collection_log_hourlycollect.collection_logcollect.database_size_statsconfig.config_collector_schedulesconfig.config_collector_run_timescollect.analysis_collection_caveatscollect.v_collection_logcollect.v_database_size_stats |
get_collection_log |
collect.collection_logcollect.serverscollect.v_collection_log |
get_collection_state |
config.config_serviceconfig.config_monitored_servers |
get_collector_cost |
collect.collector_cost |
get_collector_schedules |
config.config_collector_schedulesconfig.config_collector_run_times |
get_collector_stall_probes |
collect.collector_stall_probes |
get_command_result |
config.config_commandconfig.read_mcp_command_result |
get_custom_alert_rule |
config.custom_alert_rules |
get_custom_view |
config.custom_views |
get_investigation_evidence |
config.investigation_evidenceconfig.investigation_requests |
get_investigation_reports |
config.investigation_requestsconfig.investigation_reportsconfig.investigation_journalcollect.servers |
get_known_patterns |
config.config_known_patterns |
get_mute_rules |
config.config_mute_rules |
get_notification_routes |
config.config_notification_routesconfig.investigation_requestsconfig.config_monitored_serversconfig.server_tagsconfig.server_tag_map |
get_oversized_plan_backlog |
collect.oversized_plan_backlogcollect.servers |
get_people |
config.personconfig.person_identityconfig.person_grantconfig.config_monitored_serversconfig.server_tags |
get_read_latency |
collect.read_latency |
get_server_actions |
config.config_monitored_serversconfig.config_server_actionscollect.servers |
get_server_settings |
config.config_monitored_servers |
get_slow_reads |
collect.slow_reads |
get_store_host |
collect.store_metrics |
get_store_log |
collect.store_log_capturescollect.store_log_events |
get_store_metrics |
collect.store_metricscollect.query_store_compose_stamp_failures |
get_store_query_history |
collect.store_statement_historycollect.store_statement_capturesconfig.store_statement_stats() (function over pg_stat_statements) |
get_store_query_stats |
config.store_statement_stats() (function over pg_stat_statements)config.store_statement_stats_info() (function over pg_stat_statements_info) |
get_tool_guide |
None. The guides are built into the service. |
list_custom_alert_rules |
config.custom_alert_rulesconfig.config_alert_log |
list_custom_alert_templates |
None. The templates are built into the service. |
list_custom_views |
config.custom_views |
list_investigation_requests |
config.investigation_requestsconfig.investigation_request_alertscollect.servers |
list_query_tag_rules |
config.query_tag_rulesconfig.query_tagsconfig.query_tag_state |
list_query_tags |
config.query_tagsconfig.query_tag_assignmentsconfig.query_tag_rulesconfig.query_tag_statecollect.servers |
list_servers |
collect.serversconfig.config_monitored_serverscollect.collection_logcollect.v_collection_log |
validate_custom_alert_rule |
None. It checks the definition that you pass in. |
validate_custom_view |
None. It checks the definition that you pass in. |
wait_for_investigation_requests |
config.investigation_journalconfig.investigation_requestsconfig.investigation_request_alertscollect.servers |
Tools that change something (87)
| Tool | Store objects |
|---|---|
add_servers |
config.config_monitored_servers (insert) |
analyze_now |
config.config_commandconfig.request_mcp_command |
approve_investigation_note |
config.investigation_notes (update)config.investigation_journal (insert) |
assign_query_tag |
config.query_tag_assignments (insert/update)config.query_tagscollect.servers |
assign_server_tag |
config.server_tag_map (insert)config.server_tagscollect.servers |
claim_investigation_request |
config.investigation_requests (update claim/lease/brief)config.investigation_journal (insert)config.investigation_request_alertsconfig.config_alert_logconfig.investigation_reportscollect.analysis_findingsconfig.investigation_evidenceconfig.investigation_notesconfig.agent_environment_profilesconfig.server_tag_mapconfig.config_mute_rulesconfig.analysis_mutedcollect.plan_force_actionsconfig.service_versioncollect.servers |
clear_quiet_window |
config.config_mute_rules (update) |
close_investigation_request |
config.investigation_requests (update)config.investigation_journal (insert) |
create_custom_alert_rule |
config.custom_alert_rules |
create_custom_view |
config.custom_views |
create_known_pattern |
config.config_known_patternsconfig.config_monitored_servers (name lookup) |
create_mute_rule |
config.config_mute_rules |
create_notification_route |
config.config_notification_routes |
create_plan_guide |
No collected data. It acts on the monitored server and records the change in the agent change list. |
create_query_tag |
config.query_tags (insert) |
create_query_tag_rule |
config.query_tag_rules (insert)config.query_tagsconfig.query_tag_statecollect.servers |
create_server_tag |
config.server_tags (insert) |
delete_custom_alert_rule |
config.custom_alert_rulesconfig.custom_alert_stateconfig.config_alert_log |
delete_custom_view |
config.custom_views |
delete_known_pattern |
config.config_known_patternsconfig.config_monitored_servers (name lookup) |
delete_mute_rule |
config.config_mute_rules |
delete_notification_route |
config.config_notification_routes |
delete_query_tag |
config.query_tags (delete)config.query_tag_assignmentsconfig.query_tag_rules |
delete_query_tag_rule |
config.query_tag_rules (delete)config.query_tagsconfig.query_tag_state |
delete_server_tag |
config.server_tags (delete)config.server_tag_mapconfig.custom_alert_rules |
disable_collector |
config.config_collector_schedules |
disable_server |
config.config_monitored_servers |
dismiss_alert_history |
config.config_alert_log |
drop_plan_guide |
No collected data. It acts on the monitored server and records the change in the agent change list. |
edit_server |
config.config_monitored_serversconfig.edit_monitored_server |
enable_collector |
config.config_collector_schedules |
enable_server |
config.config_monitored_servers |
evict_cached_plan |
collect.query_statscollect.procedure_stats |
force_query_store_plan |
No collected data. It acts on the monitored server and records the change in the agent change list. |
generate_webhook_signing_key |
config.config_notificationconfig.config_notification_routes |
kill_session |
collect.server_propertiescollect.dmv_blocking_snapshots (through the view collect.v_dmv_blocking_snapshots)collect.blocked_process_reports |
merge_deadlock_signatures |
config.investigation_signature_mergesconfig.investigation_signature_days |
mute_analysis_finding |
config.analysis_mutedcollect.analysis_findings |
pause_collection |
config.config_commandconfig.config_service |
purge_expired_mute_rules |
config.config_mute_rules |
purge_now |
config.config_commandconfig.config_collector_schedules (retention overrides read for the preview)config.request_mcp_command |
recompile_module |
No collected data. It acts on the monitored server and records the change in the agent change list. |
record_investigation_feedback |
config.investigation_feedback (insert)config.investigation_reports (exists check)config.investigation_requests |
reject_investigation_note |
config.investigation_notes (update)config.investigation_journal (insert) |
reload_config |
config.config_service |
remove_server |
config.config_monitored_servers (delete)config.server_tag_map (delete)config.query_tag_assignments (delete)config.query_tag_rules (delete)config.query_tag_map (delete)config.config_collector_schedules (delete)config.config_collector_run_times (delete) |
remove_webhook_signing_key |
config.config_notificationconfig.config_notification_routes |
reset_collector_schedules |
config.config_collector_schedulesconfig.config_collector_run_times |
restore_alert_history |
config.config_alert_log |
resume_collection |
config.config_commandconfig.config_service |
run_collectors_now |
config.config_command |
save_environment_profile |
config.agent_environment_profiles (upsert/delete)config.server_tags (tag exists check)config.config_monitored_servers (server exists check)config.investigation_journal |
send_daily_health_report_now |
config.config_alert_log (insert, the alert history row)config.config_alert_settings (read)config.config_notification_routes (read)config.config_mute_rules (read)The objects that get_daily_health_report reads. |
set_agent_actions_enabled |
config.config_service |
set_alert_threshold_override |
config.config_threshold_overrides |
set_collector_databases |
config.config_collector_schedules |
set_collector_frequency |
config.config_collector_schedules |
set_collector_retention |
config.config_collector_schedules |
set_collector_run_at |
config.config_collector_run_times |
set_database_state_expected |
config.database_state_expectedcollect.database_states (read for the current state) |
set_mute_rule_enabled |
config.config_mute_rules |
set_notification_route_enabled |
config.config_notification_routes |
set_notification_route_fallback |
config.config_notification_routes |
set_quiet_window |
config.config_mute_rules (insert) |
set_server_action |
config.config_server_actions (insert/update)config.config_monitored_serverscollect.servers |
set_server_excluded_databases |
config.config_monitored_servers |
set_server_xe_session_databases |
config.config_monitored_servers |
start_practice_request |
config.investigation_requests (insert)config.investigation_request_alerts (copy/insert)config.investigation_reports (read source verdicts)config.investigation_feedback (read) |
submit_investigation_report |
config.investigation_reports (insert)config.investigation_requests (update state)config.investigation_journal (insert)config.investigation_notes (insert)config.investigation_requests (family check) |
test_connection |
config.config_commandconfig.request_mcp_command |
unassign_query_tag |
config.query_tag_assignments (delete) |
unassign_server_tag |
config.server_tag_map (delete)config.server_tags |
undo_agent_change |
config.investigation_journalconfig.config_mute_rulesconfig.custom_alert_rulesconfig.config_threshold_overridesconfig.investigation_signature_merges |
undo_plan_change |
config.investigation_journalconfig.investigation_requestsconfig.investigation_evidenceconfig.config_alert_log |
unforce_query_store_plan |
No collected data. It acts on the monitored server and records the change in the agent change list. |
unmute_analysis_finding |
config.analysis_muted |
update_alert_settings |
config.config_alert_settingsconfig.config_notification |
update_custom_alert_rule |
config.custom_alert_rules |
update_custom_view |
config.custom_views |
update_known_pattern |
config.config_known_patternsconfig.config_monitored_servers (name lookup) |
update_mute_rule |
config.config_mute_rules |
update_notification_channels |
config.config_notification |
update_notification_route |
config.config_notification_routes |
update_query_tag |
config.query_tags (update) |
update_query_tag_rule |
config.query_tag_rules (update)config.query_tagsconfig.query_tag_statecollect.servers |
update_server_tag |
config.server_tags (update) |
update_service_flags |
config.config_service |
write_investigation_note |
config.investigation_notes (insert)collect.servers (exists check) |