Statement performance data is not visible for MsSQL DB instance

[Deepak_Shingote]

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.

[AntonPineiro]

Hi,

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

Best regards

[Deepak_Shingote]

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

[PeterHyde1]

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.

[Deepak_Shingote]

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

[JoeR]

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. 

[PeterHyde1]

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?