cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL Server Data source for Custom Database Extension

tvannamuthu
Frequent Guest

Trying to migrate queries from Custom DB queries to Custom Database Extension. Created an extension for a query.

During execution, the extension provides the following warning - Connection exists but no metrics have been produced for endpoints: But I know data is available at the endpoint as the same query when run separately provides the desired output. What might be causing this error? Appreciate any insights.

 

 

6 REPLIES 6

Miguel_RinconG
Dynatrace Advisor
Dynatrace Advisor

Hi @tvannamuthu ,

Please shared your extension code. This is a query example:

  - group: User
    featureSet: User
    interval:
      minutes: 5
    query: >
      SELECT count(CustomerID) as UserCount,
      Region
      FROM Customers    
      where Region is not Null
      Group by Region
    dimensions:
      - key: custom.customquery.region
        value: col:Region
    metrics:
      - key: custom.customquery.sql.user
        value: col:UserCount

 

Hello Miguel_RinconG,

 

I was able to fix the issue by adding the database name in the monitoring configuration. It was mentioned as optional so did not add that initially but after adding the Database name extension started to fetch metrics.

 

Thanks for your reply.

Hi @tvannamuthu,

 

How you add database name ? it is using connection string ? because the prompt is showing only service name/SID

Hi @ashafingilutfi ,

 

Please see the screen shot below. Here is where database name was added.

When you try to add monitoring configuration from an SQL Server extension you get this view.

 

Hope this helps.

 

tvannamuthu_0-1724158448080.png

 

Hi there,
I have added DB name correctly and syntax also correct but sometime queries throw same error as above.
do we have any other solutions?

thanks

moin_DT1
Participant

Hi All,

We are having the same error, even though we have added Database name and other fields correctly.

Does anyone have update? @tvannamuthu @chaitanya @ashafingilutfi @Miguel_RinconG 

Thanks in advance,

Moin

Featured Posts