topic Re: Dynatrace Fullstack monitoring in Open Q&A

Dynatrace Fullstack monitoring

dharm_0101 — Wed, 15 Nov 2023 14:31:22 GMT

Dear Team,

We are using Dynatrace SaaS post installing and enabling fullstack monitoring for one of EC2 instance which is hosting MSSQL.

Getting Infor like "Cannot enable deep monitoring for this process"

Attaching screenshot for your reference and kindly suggest how we will fix this?

Thanks and Regards,

Dharmender Singh

Re: Dynatrace Fullstack monitoring

Julius_Loman — Wed, 15 Nov 2023 14:34:28 GMT

That's correct, deep monitoring does not work for Microsoft SQL Server. Metrics are collected also in infrastructure mode and you can see distributed traces from your applications. If the host does not contain any other applications which can be deep monitored, it's worth switching it to infrastructure mode.

Re: Dynatrace Fullstack monitoring

D_Miller — Wed, 15 Nov 2023 14:57:56 GMT

Hello,

Further to this. If you're looking to see the DB statements that are being run on the SQL Server DB Process then you will need to deploy the Agent in Full Stack mode on the calling application. Dynatrace will then inject into the DB connection library and create a DB Service based in this data. Then under that Service you will see the SQL Statements showing up as requests.

Re: Dynatrace Fullstack monitoring

Mizső — Wed, 15 Nov 2023 18:05:55 GMT

Hi @dharm_0101,

Agree with @Julius_Loman and @D_Miller, but If you would like other MSQSL operation metrics you can use this extensions:

In case of OA installed on VM (released in this October): Microsoft SQL Server (local) monitoring & observability | Dynatrace Hub

Without installed OA on the VM, remotly from Environment Activegate: Microsoft SQL Server monitoring & observability | Dynatrace Hub

I hope it helps.

Best regards,

Mizső