topic Re: Database services in Open Q&A

Database services

Adi_10 — Mon, 23 Dec 2024 06:29:27 GMT

Hi Team,

I have 10 host (win.linux.AIX as OS) where One Agent is running all in infra mode, Few of them are DB, FE, BE servers.

Why am I not getting any Database service name in for this server ? where 1 host have running process name as - MSSQL13.MSSQLSERVER

Do I need to enable the extension to get the Database service names ?

how I can show the traffic, latency for this DB in dashboard ?

Re: Database services

AntonPineiro — Mon, 23 Dec 2024 12:00:42 GMT

Hi,

Database services are discovered when you have OneAgent in fullstack in application servers calling databases -> https://docs.dynatrace.com/docs/shortlink/database-detection#how-database-activity-is-monitored

Do you know which database framework is being used (JDBC, ADO.NET...)?

Best regards

Re: Database services

Adi_10 — Mon, 23 Dec 2024 13:13:51 GMT

.NET, CLR, Microsoft SQL Server

Re: Database services

AntonPineiro — Mon, 23 Dec 2024 14:10:45 GMT

Hi,

Can you check which processes are calling that SQL process? For example:

If you those processes are in a host in fullstack and database service is discovered. Those Java, .NET... Must be in fullstack mode.

Best regards

Re: Database services

Adi_10 — Mon, 23 Dec 2024 14:23:28 GMT

yes calling process are in host 40 calling process and those all host are only in full stack mode only.

Re: Database services

AntonPineiro — Mon, 23 Dec 2024 14:35:27 GMT

Hi,

Can you show one of those processes in fullstack mode?

Best regards

Re: Database services

Adi_10 — Mon, 23 Dec 2024 14:57:34 GMT

Hi @AntonPineiro Checked most of the processes isn't monitored, and some monitored but dont have any data in it as no traffic

Re: Database services

AntonPineiro — Mon, 23 Dec 2024 22:44:28 GMT

Hi,

Database services will be discovered when those processes calling database will be monitored in fullstack.

I would recommend you reading How database activity is monitored.

Best regards

Re: Database services

PacoPorro — Tue, 24 Dec 2024 08:21:32 GMT

Hi , looks like the .net processes are not injected.
https://docs.dynatrace.com/docs/shortlink/dotnet

"Not every detected .NET application is instrumented by default. Dynatrace maintains a set of rules to instrument specific processes (for example, IIS application-pools, which you can extend with our own rules). To learn the basics about process group monitoring setup (automatic deep monitoring, custom monitoring rules, and built-in monitoring rules), see Set up process group monitoring."

Re: Database services

Peter_Youssef — Wed, 25 Dec 2024 05:21:25 GMT

Hi @Adi_10

Regarding detecting service name in Dynatrace:

It doesn't require installing the extension to expose the name at all.
The extension as the name suggests, gives an extended level of monitoring insights regarding the target technology, where either the OA deployment isn't an option or OA is already installed and the customer is expecting more insights.

Ref:

https://www.dynatrace.com/hub/?query=database&filter=all

Regarding DB monitoring, as simple as that:

As per the OA deployment in full stack mode and && there are service calls to the target DBs it should be detected and monitoring without any issues.

Ref:

https://docs.dynatrace.com/docs/observe/applications-and-microservices/databases/database-services-classic/how-database-activity-is-monitored#how-database-activity-is-monitored

To ensure, there is no issue with DB monitoring:

Make sure that the process group are detected && monitored properly without any remarkable issues.
Process group injection is activated properly through the monitored servers, you can validate it through UI or the oneagent cli.
Ensure the Process group deep monitoring feature is enabled.
Ensure the OA related DB services are properly activated.
If you observed an issue with process group detection, feel free to review and adjust as per the provided URL: https://docs.dynatrace.com/docs/observe/infrastructure-monitoring/process-groups/configuration/pg-detection

Hoping it adds value.

BR,

Peter