Database services

[Adi_10]

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 ?

[AntonPineiro]

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

[Adi_10]

.NET, CLR, Microsoft SQL Server

[AntonPineiro]

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

[Adi_10]

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

[AntonPineiro]

Hi,

Can you show one of those processes in fullstack mode?

Best regards

[Adi_10]

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

[AntonPineiro]

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

[PacoPorro]

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."

[Peter_Youssef · Accepted solution]

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-c...

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-de...

Hoping it adds value.

BR,

Peter