# \#sql

**URL:** https://community.dynatrace.com/tag/sql/634.md

[Latest](https://community.dynatrace.com/latest.md) · [Categories](https://community.dynatrace.com/categories.md) · [Tags](https://community.dynatrace.com/tags.md)

---

## [Error CODE: \[SQLState: S0001, ErrorCode: 18452\] in MS SQL Server extension: end point](https://community.dynatrace.com/t/error-code-sqlstate-s0001-errorcode-18452-in-ms-sql-server-extension-end-point/57042)

<div class="topic-metadata">

**Author:** [@thilinaab](https://community.dynatrace.com/u/thilinaab)\
**Replies:** 3\
**Last updated:** [September 30, 2026, 3:11pm UTC](https://community.dynatrace.com/t/error-code-sqlstate-s0001-errorcode-18452-in-ms-sql-server-extension-end-point/57042 "2026-09-30T15:11:11Z")

</div>

We are facing this error in MS SQL Server extension: MS SQL DB end point- Port 1433: \[ONGOING\] - Failed to schedule polling with message ‘Error when adding connection management layer to datasource - Login failed. The lo…

---

## [Incremental ingest of custom sql extension dimensions/metrics?](https://community.dynatrace.com/t/incremental-ingest-of-custom-sql-extension-dimensions-metrics/56910)

<div class="topic-metadata">

**Author:** [@moilejter](https://community.dynatrace.com/u/moilejter)\
**Replies:** 1\
**Last updated:** [September 10, 2026, 3:52am UTC](https://community.dynatrace.com/t/incremental-ingest-of-custom-sql-extension-dimensions-metrics/56910 "2026-09-10T03:52:36Z")

</div>

Hi! We’ve just started looking into custom sql extensions, to run database queries and make the results available within dynatrace. The simple case seems straightforward enough: run a database query, and the complete r…

---

## [Custom DB Query extension not providing the correct count](https://community.dynatrace.com/t/custom-db-query-extension-not-providing-the-correct-count/56516)

<div class="topic-metadata">

**Author:** [@tdavison2](https://community.dynatrace.com/u/tdavison2)\
**Replies:** 3\
**Last updated:** [July 22, 2026, 8:14am UTC](https://community.dynatrace.com/t/custom-db-query-extension-not-providing-the-correct-count/56516 "2026-07-22T08:14:55Z")

</div>

Hello, I’ve created a Custom Extension that runs a SQL Query that just provides a “count”. This runs every 1 min, but, the returned count is not accurate. It should be around 60+ per minute, but Dynatrace is showing s…

---

## [How to get Deadlock Chain in SQL Server](https://community.dynatrace.com/t/how-to-get-deadlock-chain-in-sql-server/56450)

<div class="topic-metadata">

**Author:** [@deepufrancis](https://community.dynatrace.com/u/deepufrancis)\
**Replies:** 1\
**Last updated:** [July 15, 2026, 2:24pm UTC](https://community.dynatrace.com/t/how-to-get-deadlock-chain-in-sql-server/56450 "2026-07-15T14:24:45Z")

</div>

In the database Explorer table, it shows the occurrence of Deadlocks but how to narrow down to the source and victim queries. There is no option to drill down from the graph.

---

## [SQL Server Extension failing to connect to server](https://community.dynatrace.com/t/sql-server-extension-failing-to-connect-to-server/55352)

<div class="topic-metadata">

**Author:** [@Troy](https://community.dynatrace.com/u/Troy)\
**Replies:** 11\
**Last updated:** [April 30, 2026, 1:47pm UTC](https://community.dynatrace.com/t/sql-server-extension-failing-to-connect-to-server/55352 "2026-04-30T13:47:59Z")

</div>

Using the Microsoft SQL Server extension we connected to several instances and was working flawlessly for quite some time, Recently we are noticing 2012 servers are getting this error: Cannot connect to database {serve…

---

## [SQL Server Instance Offline Monitoring](https://community.dynatrace.com/t/sql-server-instance-offline-monitoring/53073)

<div class="topic-metadata">

**Author:** [@Troy](https://community.dynatrace.com/u/Troy)\
**Replies:** 5\
**Last updated:** [April 16, 2026, 7:51am UTC](https://community.dynatrace.com/t/sql-server-instance-offline-monitoring/53073 "2026-04-16T07:51:02Z")

</div>

Hello - We are trying to monitor SQL Server instances being offline via the Microsoft SQL Server Extension. As I can tell theres no easy metric for instance state. and the uptime does not seem to be 100% reliable. using…

---

## [SQL Extensions Troubleshooting Guide](https://community.dynatrace.com/t/sql-extensions-troubleshooting-guide/52465)

<div class="topic-metadata">

**Author:** [@andrzej-skiba](https://community.dynatrace.com/u/andrzej-skiba)\
**Replies:** 6\
**Last updated:** [March 13, 2026, 7:46am UTC](https://community.dynatrace.com/t/sql-extensions-troubleshooting-guide/52465 "2026-03-13T07:46:51Z")

</div>

Summary This troubleshooting article should help you resolve the most common issues for SQL extensions Failed to assign monitoring configuration Problem As SQL extension fast checks only attempt to verify connectivity…

---

## [SQL Deadlock alerts on "database" level instead of "Instance" level](https://community.dynatrace.com/t/sql-deadlock-alerts-on-database-level-instead-of-instance-level/55123)

<div class="topic-metadata">

**Author:** [@sharjeelb](https://community.dynatrace.com/u/sharjeelb)\
**Replies:** 6\
**Last updated:** [March 2, 2026, 4:51pm UTC](https://community.dynatrace.com/t/sql-deadlock-alerts-on-database-level-instead-of-instance-level/55123 "2026-03-02T16:51:07Z")

</div>

We are currently getting the SQL related deadlock alerts on instance level, but we are looking to get these alerts on database level and looking to see if there’s any solution available to achieve this goal.

---

## [Why does dynatrace shows 2x SQL Commit](https://community.dynatrace.com/t/why-does-dynatrace-shows-2x-sql-commit/54888)

<div class="topic-metadata">

**Author:** [@danielkl](https://community.dynatrace.com/u/danielkl)\
**Replies:** 1\
**Last updated:** [February 26, 2026, 1:17pm UTC](https://community.dynatrace.com/t/why-does-dynatrace-shows-2x-sql-commit/54888 "2026-02-26T13:17:59Z")

</div>

Hi, I am investigating a database issue where commit operations seem to take too much time. My application creates two transactions. First, it starts the main transaction. Then it starts a second transaction, which com…

---

## [Monitor SQL Server Jobs Using DQL for Performance Insights](https://community.dynatrace.com/t/monitor-sql-server-jobs-using-dql-for-performance-insights/52087)

<div class="topic-metadata">

**Author:** [@DBAJames](https://community.dynatrace.com/u/DBAJames)\
**Replies:** 3\
**Last updated:** [January 28, 2026, 11:35am UTC](https://community.dynatrace.com/t/monitor-sql-server-jobs-using-dql-for-performance-insights/52087 "2026-01-28T11:35:46Z")

</div>

In the dashboard i have added the DQL from the example but it doesnt work as suggested. if i set it to 5 mins, i dont see any failed jobs. if i set it to 30 i get lots of duplication and sometimes ones that are no long…

---

## [Microsft SQL Server Extension - Best Practices](https://community.dynatrace.com/t/microsft-sql-server-extension-best-practices/53575)

<div class="topic-metadata">

**Author:** [@Joao1](https://community.dynatrace.com/u/Joao1)\
**Replies:** 7\
**Last updated:** [January 28, 2026, 10:21am UTC](https://community.dynatrace.com/t/microsft-sql-server-extension-best-practices/53575 "2026-01-28T10:21:23Z")

</div>

Hello, I’m currently implementing a solution to monitor various Microsoft SQL Server Instances and Databases in a client. I’m currently having trouble with some metrics not having information about some databases. I was…

---

## [Custom Extension Creator - SQL Extension - Ingesting large data into logs](https://community.dynatrace.com/t/custom-extension-creator-sql-extension-ingesting-large-data-into-logs/54484)

<div class="topic-metadata">

**Author:** [@chris\_cho](https://community.dynatrace.com/u/chris_cho)\
**Replies:** 5\
**Last updated:** [January 23, 2026, 4:38pm UTC](https://community.dynatrace.com/t/custom-extension-creator-sql-extension-ingesting-large-data-into-logs/54484 "2026-01-23T16:38:36Z")

</div>

Hello, I got an initiative ingesting data from a SQL server into logs. For this, I checked the features provided by the Custom Extension Creator, selecting and extracting SQL data. It worked quite well, but I think th…

---

## [How to enable capturing of SQL bind variables? (Values are masked)](https://community.dynatrace.com/t/how-to-enable-capturing-of-sql-bind-variables-values-are-masked/54605)

<div class="topic-metadata">

**Author:** [@HuseynNajafli](https://community.dynatrace.com/u/HuseynNajafli)\
**Replies:** 2\
**Last updated:** [January 13, 2026, 2:20pm UTC](https://community.dynatrace.com/t/how-to-enable-capturing-of-sql-bind-variables-values-are-masked/54605 "2026-01-13T14:20:02Z")

</div>

Hi everyone, I’m currently trying to analyze database performance, but Dynatrace is masking all SQL parameters/values (Oracle, PostgreSQL, MSSQL, MySQL) in the “Database Statements” view. Every value appears as \*\*\*\*\*. I…

---

## [Python Extension SDK - Why pyodbc doesn't get installed on ActiveGates Python runtime environment.](https://community.dynatrace.com/t/python-extension-sdk-why-pyodbc-doesnt-get-installed-on-activegates-python-runtime-environment/54491)

<div class="topic-metadata">

**Author:** [@chris\_cho](https://community.dynatrace.com/u/chris_cho)\
**Replies:** 8\
**Last updated:** [December 31, 2025, 3:15pm UTC](https://community.dynatrace.com/t/python-extension-sdk-why-pyodbc-doesnt-get-installed-on-activegates-python-runtime-environment/54491 "2025-12-31T15:15:53Z")

</div>

Hello, I am using Dynatrace Python Extension SDK to create a custom extension ingesting data from a SQL server, by using pyodbc Python library. For this I have the configuration: development workstation - Python 3.10 u…

---

## [Issue with Simba Spark ODBC Driver and Spark SQL Queries after Dynatrace Injection](https://community.dynatrace.com/t/issue-with-simba-spark-odbc-driver-and-spark-sql-queries-after-dynatrace-injection/54505)

<div class="topic-metadata">

**Author:** [@HuseynNajafli](https://community.dynatrace.com/u/HuseynNajafli)\
**Replies:** 1\
**Last updated:** [December 30, 2025, 12:13pm UTC](https://community.dynatrace.com/t/issue-with-simba-spark-odbc-driver-and-spark-sql-queries-after-dynatrace-injection/54505 "2025-12-30T12:13:19Z")

</div>

Hello We are connecting to a Spark SQL database via the Simba Spark ODBC driver. When OneAgent is disabled, no issues occur. However, once OneAgent is injected, some queries return a 200 response, while others encounter…

---

## [Metric ingestion timestamp from Custom Extensions](https://community.dynatrace.com/t/metric-ingestion-timestamp-from-custom-extensions/54409)

<div class="topic-metadata">

**Author:** [@Yann\_Buccellato](https://community.dynatrace.com/u/Yann_Buccellato)\
**Replies:** 1\
**Last updated:** [December 20, 2025, 4:20am UTC](https://community.dynatrace.com/t/metric-ingestion-timestamp-from-custom-extensions/54409 "2025-12-20T04:20:20Z")

</div>

Hello fellow community members. We are executing a database query via a Dynatrace extension, which creates a metric based on the query results. I would like to understand whether it is possible to control the timestamp…

---

## [Seeking help on SQL query for the group level in SQL Data Source migration to Extension 2.0](https://community.dynatrace.com/t/seeking-help-on-sql-query-for-the-group-level-in-sql-data-source-migration-to-extension-2-0/50646)

<div class="topic-metadata">

**Author:** [@DarshanDoshi](https://community.dynatrace.com/u/DarshanDoshi)\
**Replies:** 1\
**Last updated:** [December 19, 2025, 11:17am UTC](https://community.dynatrace.com/t/seeking-help-on-sql-query-for-the-group-level-in-sql-data-source-migration-to-extension-2-0/50646 "2025-12-19T11:17:29Z")

</div>

Hi There, I am working on migration task on our Custom DB Query written in python on Dynatrace managed using extension 1.0 to Extension 2.0 - SQL Data Source. Though it is successful, I wasn’t able to define it as group…

---

## [Azure SQL Managed Instance - Agent Jobs monitoring with Dynatrace SQL Extension](https://community.dynatrace.com/t/azure-sql-managed-instance-agent-jobs-monitoring-with-dynatrace-sql-extension/54158)

<div class="topic-metadata">

**Author:** [@kayjayeff1](https://community.dynatrace.com/u/kayjayeff1)\
**Replies:** 3\
**Last updated:** [December 18, 2025, 1:20pm UTC](https://community.dynatrace.com/t/azure-sql-managed-instance-agent-jobs-monitoring-with-dynatrace-sql-extension/54158 "2025-12-18T13:20:08Z")

</div>

Based on the current SQL Extension documentation it doesn’t look like it can monitor Azure SQL Managed Instance SQL Agent Jobs. In the attached screenshot it references “SQL Server (all versions)”; however, in other sec…

---

## [Permissions for MySQL Monitoring Extension](https://community.dynatrace.com/t/permissions-for-mysql-monitoring-extension/5520)

<div class="topic-metadata">

**Author:** [@technical\_admin](https://community.dynatrace.com/u/technical_admin)\
**Replies:** 6\
**Last updated:** [November 19, 2025, 3:35am UTC](https://community.dynatrace.com/t/permissions-for-mysql-monitoring-extension/5520 "2025-11-19T03:35:07Z")

</div>

When trying to enable the extension I have to provide a user/password. However there is no indication what permissions this user account needs to have. Is it enough if he has the MonitorAdmin permissions?

---

## [Help with YAML customization for Microsoft SQL Server Extension](https://community.dynatrace.com/t/help-with-yaml-customization-for-microsoft-sql-server-extension/54011)

<div class="topic-metadata">

**Author:** [@Joao1](https://community.dynatrace.com/u/Joao1)\
**Replies:** 1\
**Last updated:** [November 7, 2025, 12:16pm UTC](https://community.dynatrace.com/t/help-with-yaml-customization-for-microsoft-sql-server-extension/54011 "2025-11-07T12:16:53Z")

</div>

Hi, If possible, i need help with something related to the YAML of the extension. I was editing it for a custom extension using the same data source. I was trying to edit a query which is used for the database state, to…

---

## [How can I find the skipped urls "At least x contributors were skipped because they occurred extremely rarely"](https://community.dynatrace.com/t/how-can-i-find-the-skipped-urls-at-least-x-contributors-were-skipped-because-they-occurred-extremely-rarely/53949)

<div class="topic-metadata">

**Author:** [@runatyr](https://community.dynatrace.com/u/runatyr)\
**Replies:** 3\
**Last updated:** [October 31, 2025, 7:51pm UTC](https://community.dynatrace.com/t/how-can-i-find-the-skipped-urls-at-least-x-contributors-were-skipped-because-they-occurred-extremely-rarely/53949 "2025-10-31T19:51:37Z")

</div>

Helllo: we are trying to clean up and verify certain web pages that do not see a high level of use (or any) so it can be removed. When we go to a web service and select “view all request details” we get the list and then…

---

## [SQL Extension for Custom Queries using Microsoft Entra ID](https://community.dynatrace.com/t/sql-extension-for-custom-queries-using-microsoft-entra-id/53843)

<div class="topic-metadata">

**Author:** [@john\_schell\_avo](https://community.dynatrace.com/u/john_schell_avo)\
**Replies:** 1\
**Last updated:** [October 24, 2025, 6:51am UTC](https://community.dynatrace.com/t/sql-extension-for-custom-queries-using-microsoft-entra-id/53843 "2025-10-24T06:51:55Z")

</div>

Hi everyone, We need to make use of the Custom SQL Query Extension however, Microsoft Entra ID is not an option for authentication when adding the SQL Server Endpoint in the configuration. Has anyone figured out how…

---

## [SQL listener in Synthetic Monitoring](https://community.dynatrace.com/t/sql-listener-in-synthetic-monitoring/53217)

<div class="topic-metadata">

**Author:** [@MikeL](https://community.dynatrace.com/u/MikeL)\
**Replies:** 7\
**Last updated:** [October 6, 2025, 1:01pm UTC](https://community.dynatrace.com/t/sql-listener-in-synthetic-monitoring/53217 "2025-10-06T13:01:16Z")

</div>

Would anyone know the proper syntax to use when adding a Synthetic endpoints, then adding both IP & Listener URL both using port 1433, to be monitored. in our case we’d like to both DNS & IP to be monitored. Here’s an …

---

## [Extension Creation problem](https://community.dynatrace.com/t/extension-creation-problem/53532)

<div class="topic-metadata">

**Author:** [@ArneV](https://community.dynatrace.com/u/ArneV)\
**Replies:** 8\
**Last updated:** [October 6, 2025, 12:50pm UTC](https://community.dynatrace.com/t/extension-creation-problem/53532 "2025-10-06T12:50:28Z")

</div>

Im trying to setup my environment to create a SQL Extension. However i get 2 errors, i guess the first part is due to the second part. The environment is using a self signd certificate, but how can i skip the validatio…

---

## [SQL Extension cron schedule question](https://community.dynatrace.com/t/sql-extension-cron-schedule-question/53527)

<div class="topic-metadata">

**Author:** [@susmita\_k](https://community.dynatrace.com/u/susmita_k)\
**Replies:** 1\
**Last updated:** [September 26, 2025, 6:13am UTC](https://community.dynatrace.com/t/sql-extension-cron-schedule-question/53527 "2025-09-26T06:13:05Z")

</div>

Is there a way to schedule a query to run twice a day for db sql extension ? I want to run the query every day at 4:30 am and 10 pm.

---

## [SQL Extensions Kerberos Authentication](https://community.dynatrace.com/t/sql-extensions-kerberos-authentication/53466)

<div class="topic-metadata">

**Author:** [@Erica\_Kelly](https://community.dynatrace.com/u/Erica_Kelly)\
**Replies:** 1\
**Last updated:** [September 24, 2025, 2:12pm UTC](https://community.dynatrace.com/t/sql-extensions-kerberos-authentication/53466 "2025-09-24T14:12:51Z")

</div>

I’m having difficulty establishing Kerberos authentication to a SQL server with the SQL Server Extension. If anyone has an example of the configuration that worked for you that would be great. I don’t know the format eve…

---

## [Add custom Informix metrics to extension](https://community.dynatrace.com/t/add-custom-informix-metrics-to-extension/53330)

<div class="topic-metadata">

**Author:** [@NicoleMT](https://community.dynatrace.com/u/NicoleMT)\
**Replies:** 1\
**Last updated:** [September 13, 2025, 12:46pm UTC](https://community.dynatrace.com/t/add-custom-informix-metrics-to-extension/53330 "2025-09-13T12:46:17Z")

</div>

Hello Community, I have a question. Our client is using the IBM Informix extension, which has been very useful. However, the client requires additional metrics that are not included in the extension, such as checkpoint …

---

## [SQL extensions: Query behind a metric](https://community.dynatrace.com/t/sql-extensions-query-behind-a-metric/52466)

<div class="topic-metadata">

**Author:** [@andrzej-skiba](https://community.dynatrace.com/u/andrzej-skiba)\
**Replies:** 1\
**Last updated:** [July 16, 2025, 9:23am UTC](https://community.dynatrace.com/t/sql-extensions-query-behind-a-metric/52466 "2025-07-16T09:23:30Z")

</div>

Summary This troubleshooting guide will help you look up the SQL query that is running to pull data for a particular metric for a SQL extension. Problem When working with metric data generated by a SQL extension sometim…

---

## [SQL Extension Build Error ("Extension signature is not valid")](https://community.dynatrace.com/t/sql-extension-build-error-extension-signature-is-not-valid/51849)

<div class="topic-metadata">

**Author:** [@Eyad](https://community.dynatrace.com/u/Eyad)\
**Replies:** 3\
**Last updated:** [July 8, 2025, 5:32am UTC](https://community.dynatrace.com/t/sql-extension-build-error-extension-signature-is-not-valid/51849 "2025-07-08T05:32:34Z")

</div>

Hi all, I’m trying to build a SQL extension and was following the Dynatrace tutorial video. However, when I get to the build step, I encounter the following error: { “code”: 400, “message”: “Extension signature i…

---

## [Set up custom alerting for specific MySQL/MariaDB changes](https://community.dynatrace.com/t/set-up-custom-alerting-for-specific-mysql-mariadb-changes/52133)

<div class="topic-metadata">

**Author:** [@NathanW1990](https://community.dynatrace.com/u/NathanW1990)\
**Replies:** 2\
**Last updated:** [June 18, 2025, 7:23am UTC](https://community.dynatrace.com/t/set-up-custom-alerting-for-specific-mysql-mariadb-changes/52133 "2025-06-18T07:23:43Z")

</div>

Hi, I need to set up alerts on DT to basically say if a certain criteria for MariaDB/MySQL is being met. We currently use Datadog but we’re moving away in August, we have an alert in there which monitors the Galera ‘ws…

[Next page](https://community.dynatrace.com/tag/sql/634.md?match_all_tags=true&page=1&tags%5B%5D=sql)
