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

[Adi_10]

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 ?

[Esam_Eid]

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 

[Adi_10]

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

MSSQL13.MSSQLSERVER

then i have added the host in management zone.

[Peter_Youssef]

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-recommend...
• 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-z...

Best Practices:

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

Hoping it helps.

BR,

Peter

[Peter_Youssef]

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:

• https://docs.dynatrace.com/docs/observe/applications-and-microservices/databases/database-services-c...
• https://docs.dynatrace.com/docs/observe/applications-and-microservices/databases/database-services-c...

Analyze DB:

• https://docs.dynatrace.com/docs/observe/applications-and-microservices/databases/database-services-c...
• https://docs.dynatrace.com/docs/observe/applications-and-microservices/databases/database-services-c...

Hoping it adds value.

KR,

Peter

[Peter_Youssef]

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

[Peter_Youssef]

Hi @Adi_10 

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

• https://docs.dynatrace.com/docs/analyze-explore-automate/dashboards-and-notebooks/dashboards-new
• https://docs.dynatrace.com/docs/analyze-explore-automate/dashboards-classic/dashboards/create-dashbo...
• https://docs.dynatrace.com/docs/analyze-explore-automate/dashboards-classic

Hoping it helps.

KR,

Peter

[Peter_Youssef]

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:

• https://docs.dynatrace.com/docs/observe/applications-and-microservices/services/analysis/service-flo...
• https://docs.dynatrace.com/docs/observe/applications-and-microservices/services/analysis/service-flo...

BR,

Peter

[PacoPorro]

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)

[Peter_Youssef]

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

[Adi_10]

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,

[PacoPorro · Accepted solution]

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

[Adi_10]

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

[Peter_Youssef]

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

[Adi_10]

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

[Abidyaseen · Accepted solution]

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

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

1. type(SERVICE) – Filters entities to only include those of type "SERVICE."
2. databaseName.exists() – Ensures that the databaseName attribute exists (i.e., applies only to services linked to a database).
3. 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-c...