topic Re: How can we configure the databases in the management zone, with and without tags? in Open Q&A

How can we configure the databases in the management zone, with and without tags?

Adi_10 — Mon, 23 Dec 2024 07:45:09 GMT

1. How can we configure the databases in the management zone, with and without tags?

2. If we have to check the Host name for the Database,

then how to check?

where to check?

3. What journry dashboard ?

Re: Database

Esam_Eid — Sat, 21 Dec 2024 13:30:58 GMT

You can add it to the management zone using the database service name

if you install the oneagent in the db host. Then from the hosts menu you can find it. But if you install extension and configured the database monitoring most probably the extension dashboard will show you all the needed details

Re: Database

Adi_10 — Mon, 23 Dec 2024 06:49:36 GMT

Hi, i have found in host db name with - Process name as -

MSSQL13.MSSQLSERVER

then i have added the host in management zone.

Re: Database

Peter_Youssef — Mon, 23 Dec 2024 07:14:59 GMT

Hi @Adi_10

As simple as that:
For Tagging rules:

You will create automatically applied tags, it will act as a label for the monitoring entities for entity differentiation.
https://docs.dynatrace.com/docs/manage/tags-and-metadata/setup/how-to-define-tags
https://docs.dynatrace.com/docs/manage/tags-and-metadata/basic-concepts/best-practices-and-recommendations-for-tagging
https://www.youtube.com/watch?v=fcVKuSvhbpU

Tips && Tricks:

https://www.youtube.com/watch?v=kSsbQngFDiE

For Management Zone:

You will create management zone rules to add the required monitored entities and limit the access as per the required permissions according to the RBAC rule.
https://docs.dynatrace.com/docs/manage/identity-access-management/permission-management/management-zones

Best Practices:

https://docs.dynatrace.com/docs/manage/tags-and-metadata/basic-concepts/best-practice-tagging-at-scale

Hoping it helps.

BR,

Peter

Re: Database

Peter_Youssef — Mon, 23 Dec 2024 07:20:01 GMT

Hi @Adi_10

Regarding the database service monitoring:

It's detected && monitored in Dynatrace through the app services calls that means when the monitored entities call a database it will be detected and monitored.
Upon detection > Under application observability > database services > select the service of your interest > under properties && tags you will find full details.

References:

Analyze DB:

Hoping it adds value.

KR,

Peter

Re: Database

Peter_Youssef — Mon, 23 Dec 2024 07:21:55 GMT

Hi @Adi_10

For detailed info about DB monitoring in Dynatrace either classic or new Dynatrace, feel free to delve into:

https://docs.dynatrace.com/docs/observe/applications-and-microservices/databases

BR,

Peter

Re: Database

Peter_Youssef — Mon, 23 Dec 2024 07:24:29 GMT

Hi @Adi_10

Regarding the Dashboards and visualizations in Dynatrace, feel free to review:

Hoping it helps.

KR,

Peter

Re: Database

Peter_Youssef — Mon, 23 Dec 2024 07:29:37 GMT

Hi @Adi_10

You can also check the service flow from the services that are calling the DB.
You can also check the backtrace as well for the DB.

Ref:

BR,

Peter

Re: How can we configure the databases in the management zone, with and without tags?

PacoPorro — Mon, 23 Dec 2024 08:56:27 GMT

Using the entity selector you can do something like this
type(SERVICE),databaseName.exists(),toRelationships.calls(type(SERVICE),tag(XXXXX))

"database services called by services with tag XXXXX)

Re: How can we configure the databases in the management zone, with and without tags?

Peter_Youssef — Mon, 23 Dec 2024 09:07:43 GMT

Hi @Adi_10

you can use the provided entity selector provided by @PacoPorro in management zone rules.
Regarding the db tagging rules, you can define it based on database service technology or database service name, .. more options to select from according to the actual monitored DBs properties under properties && tags section.

BR,

Peter

Re: How can we configure the databases in the management zone, with and without tags?

Adi_10 — Mon, 23 Dec 2024 09:18:55 GMT

Got It, Thanks,

@Peter_Youssef @PacoPorro @Esam_Eid

I am currently facing issue as: - Installed one agent on window db host with running process name - MSSQL13.MSSQLSERVER but still not getting any database service names at - Under application observability > database services >

How can I make it appears? do i need extension to get data from DB to Dynatrace as database service,

Re: How can we configure the databases in the management zone, with and without tags?

PacoPorro — Mon, 23 Dec 2024 09:19:55 GMT

Carefully read this doc entry

https://docs.dynatrace.com/docs/shortlink/database-detection#how-database-activity-is-monitored

"When OneAgent is installed on the host that runs your application server, Dynatrace ensures that all database statements are logged, as long as deep monitoring is active for the calling processes and the database request is appended to an existing PurePath® distributed trace. As soon as the first calls to your database are monitored, the Databases page is updated with the new database entry."

Re: How can we configure the databases in the management zone, with and without tags?

Adi_10 — Mon, 23 Dec 2024 09:59:54 GMT

I am getting the distributed traces for my application and webservices -

but service type database is empty getting no result for the selected management zone

Re: How can we configure the databases in the management zone, with and without tags?

Peter_Youssef — Mon, 23 Dec 2024 11:15:31 GMT

Hi @Adi_10

Kindly check the storage and retention settings on the monitored environment to ensure there is no issue with the data retention as per the attached example:

BR,

Peter

Re: How can we configure the databases in the management zone, with and without tags?

Adi_10 — Mon, 23 Dec 2024 13:28:02 GMT

Checked no issues here at monitoring environment, as other management zones are getting the data for DB services

Re: How can we configure the databases in the management zone, with and without tags?

Abidyaseen — Mon, 03 Feb 2025 07:10:09 GMT

type(SERVICE),databaseName.exists(),toRelationships.calls(type(SERVICE),tag("XXXXX"))

the condition defines access rules based on entity relationships. Let's break it down:

type(SERVICE) – Filters entities to only include those of type "SERVICE."
databaseName.exists() – Ensures that the databaseName attribute exists (i.e., applies only to services linked to a database).
toRelationships.calls(type(SERVICE),tag("XXXXX")) – Checks if the service calls another service that has the tag "XXXXX."

this is simple rule to put in mgt zones and tags that will help you to add your db to related ones you can see more details on the below link

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