topic Re: Statement performance data is not visible for MsSQL DB instance in Extensions

Statement performance data is not visible for MsSQL DB instance

Deepak_Shingote — Fri, 07 Mar 2025 07:37:24 GMT

Hi Team,

I'm trying to get the statement performance data over latest DT UI for MsSQL DB. We have configured Extension for the same successfully but unable to get the data. I have attached snip for reference. Kindly assist.

Re: Statement performance data is not visible for MsSQL DB instance

AntonPineiro — Thu, 06 Mar 2025 16:42:48 GMT

Hi,

Not sure about this new Databases app, but is it possible those fields are coming by OneAgent instead of extension?

Best regards

Re: Statement performance data is not visible for MsSQL DB instance

Deepak_Shingote — Mon, 17 Mar 2025 11:13:30 GMT

Hi,

No, we need to configure extension to fetch this data. In-fact without installing OneAgent we can still be able to see the required data by using extension.

Thanks and Regards,
Deepak Shingote

Re: Statement performance data is not visible for MsSQL DB instance

PeterHyde1 — Wed, 13 Aug 2025 20:00:31 GMT

Hi @Deepak_Shingote , I'm curious if you found a solution to this problem. I see the same issue in my newly setup extension. Other database information for MSSQL is available such as latches, locks, blocks, logins, uptime, cpu, memory, etc, but the "statement performance analysis" section is blank. This is across all SQL servers in our environment, which are Azure Managed Instances.

Re: Statement performance data is not visible for MsSQL DB instance

JoeR — Thu, 14 Aug 2025 12:56:28 GMT

If I remember correctly when we tested this, you have to make sure the user you are using in the extension has DBO rights to the Database and is the owner of the Database otherwise it defaults to Master. That may fix the issue.

Re: Statement performance data is not visible for MsSQL DB instance

Deepak_Shingote — Thu, 14 Aug 2025 13:14:56 GMT

Hi Peter,

To get the MSSQL data over latest UI, you need to configure extension from the dynatrace Hub. There are few pre-requisites which is available in below link

https://www.dynatrace.com/hub/detail/microsoft-sql-server-2/?query=MSSQL&filter=all

with this you need to configure the extension using DB name and instance name.

Best Regards,
Deepak Shingote

Re: Statement performance data is not visible for MsSQL DB instance

PeterHyde1 — Thu, 14 Aug 2025 14:57:32 GMT

Based on the above replies, and some experimentation, I think I understand the problem and the solution. The solution seems to be that we have to individually connect to each database using the SQL server extension. In our environment, we have hundreds of databases on just a few servers, so this would be quite tedious. Has anyone been able to add a server connection without specifying a database, and have the "statement performance analysis" check the query logs for all databases on that server?